Time between events

[Rudi Groenewald]

Hi all,

I have got the following data in a report which I have created (just to show
you clearly what my main report and data looks like)

In my next report, I would have to show, how many minutes was spent on Slag,
how many on basket, and how many delay and so on.

How would my query look like if I had to calculate it with the following
data? My coloumn names from left to right :

RECEIVED , STATUSTEXT, SPEED, PLACE, DIRECTION.

Anyone know? Thanks
R

11:05 AM Delay 10 LHF Area S
11:06 AM Basket 11 LHF Area SW
11:07 AM Basket 0 LID S
11:08 AM Basket 10 LID SW
11:08 AM Delay 3 LID SW
11:09 AM Delay 3 Conarc2 E
11:10 AM Slag 0 Conarc1 SW
11:11 AM Slag 3 Conarc1 SW
11:12 AM Slag 0 LID S
11:13 AM Slag 8 LID S
11:13 AM Delay 5 LID S
11:14 AM Slag 0 LID S
11:15 AM Slag 5 LID SW
11:16 AM Slag 7 Conarc2 E
11:16 AM Delay 0 Conarc2 E
11:17 AM Delay 0 Conarc1 N
11:18 AM Delay 0 LID S
11:19 AM Slag 0 LID S
11:20 AM Slag 6 LHF Area SW
11:21 AM Slag 6 Total NW
11:22 AM Slag 7 Total S
11:23 AM Slag 8 Wash Bay E
11:24 AM Slag 7 Wash Bay S
11:25 AM Slag 0 Wash Bay S
11:26 AM Slag 0 Wash Bay S
11:27 AM Slag 5 Wash Bay S
11:28 AM Slag 0 Wash Bay S
11:29 AM Slag 3 Wash Bay S
11:30 AM Slag 7 Wash Bay S
11:31 AM Slag 11 Total S
11:32 AM Slag 10 LHF Area S
11:33 AM Slag 7 LID SW
11:34 AM Slag 3 LID SW
11:34 AM Delay 0 LID SW
11:35 AM Delay 1 LID SW
11:36 AM Delay 0 LID S
11:37 AM Delay 0 LID S
11:38 AM Delay 0 LHF Area W
11:39 AM Delay;Ignition off 0 LID S
11:53 AM 1st Startup 0 LHF Area W
11:54 AM Delay 5 LID SE
11:55 AM Delay 0 Conarc1 SW
11:56 AM Delay 0 Conarc1 SW
11:57 AM Delay 0 Conarc1 SW
11:58 AM Delay 0 Conarc1 SW
11:59 AM Delay 0 Conarc1 SW
12:00 PM Delay 0 Conarc1 SW
12:01 PM Delay 0 Conarc1 SW
12:01 PM Slag 0 Conarc1 SW
12:02 PM GPS unlocked 0 Conarc1 SW
12:02 PM Excess Idle 5 LID E
12:03 PM Slag 0 LID S
12:04 PM Delay 4 LID S
12:05 PM Slag 0 LID SW
12:06 PM Slag 5 LID S
12:07 PM Slag 6 LID NE
12:08 PM GPS unlocked 0 LID NE
12:08 PM Delay 0 LID NE
12:09 PM Delay 0 LID NW
12:09 PM Delay;Ignition off 0 LID NW
12:25 PM 1st Startup 0 Conarc2 S
12:26 PM Delay 0 Conarc2 SW
12:27 PM Slag 5 Conarc2 SW
12:27 PM Slag 1 Conarc2 S
12:28 PM Delay 0 Conarc2 S
12:29 PM Delay 11 LID SW
12:30 PM Basket 0 LID SW
12:31 PM Basket 11 LID N
12:32 PM Basket 3 Conarc2 E
12:32 PM Delay 0 Conarc2 E
12:33 PM Delay 11 LID SW
12:33 PM Basket 0 LID W
12:35 PM Basket 10 LID NW
12:35 PM Basket 5 Conarc1 W
12:36 PM Basket 0 Conarc1 W
12:37 PM Delay 0 Conarc1 SW
12:38 PM Delay 0 Conarc2 S
12:39 PM Delay;Ignition off 0 Conarc2 S
12:51 PM 1st Startup 0 Conarc2 SW
12:52 PM Delay 0 Conarc2 SW
12:53 PM Delay 0 Conarc2 S
12:54 PM Slag 0 Conarc2 S
12:55 PM Slag 5 Conarc2 SE
12:56 PM Slag 0 LID S
12:57 PM Delay 7 LID S
12:57 PM Slag 0 LID SW
12:58 PM Slag 12 LID W
12:59 PM Slag 9 Conarc1 W
01:00 PM Delay 0 Conarc1 W
01:01 PM Delay 3 LID S
01:02 PM Slag 0 LID S
01:03 PM Slag 6 LHF Area S
01:04 PM Slag 6 Total NW
01:05 PM Slag 5 Total S
01:06 PM Slag 6 Wash Bay N
01:07 PM Slag 5 Wash Bay SE
01:08 PM Delay 4 Wash Bay S
01:09 PM Delay 0 Wash Bay S
01:09 PM Slag 0 Wash Bay S
01:10 PM Slag 0 Wash Bay S
01:11 PM Slag 0 Wash Bay S
01:12 PM Slag 0 Wash Bay S
01:13 PM Slag 8 Wash Bay S
01:14 PM Slag 11 Wash Bay N
01:15 PM Slag 10 Total N
01:16 PM Slag 10 LID N
01:17 PM Slag 0 Conarc2 E
01:18 PM Slag 0 Conarc2 E
01:19 PM Slag 11 Conarc2 SE

 

[Wayne Morgan]

Since it appears that you are doing everything in one minute intervals, you
could probably just get the count of the number of records that have Slag in
the StatusText field. You could put a textbox in the footer of the report
and use DCount to get the value. You could also use the ability of textboxes
in a report to do a running sum. Set the textbox's control source to

=IIf([StatusText]="Slag", 1, 0)

and set the running sum property of the textbox to over group or over all as
appropriate. You could have one of these textboxes for each value. Make the
box hidden if desired. In the report's footer, you would have a textbox that
refers to the above textbox so that the footer would display the final
total.

=[txtSlagSum]