Combine info from queries

[gcutter]

I have two queries 1st one gives StartTime and EndTime of conveyor moving
that uses subquery to query a float table.
StartTime EndTime
05/01/2009 05:03:20 05/01/2009 05:16:55
05/01/2009 05:20:23 05/01/2009 05:22:09
05/01/2009 05:22:52 05/01/2009 05:33:54
05/01/2009 06:52:51 05/01/2009 07:35:37
05/01/2009 07:41:39 05/01/2009 07:45:34

The second query gives StartTime, EndTime, and LineSpeed of conveyor moving.
Basically records the time the LineSpeed was set to.

What I am trying to do is calculate line travel per day so I need to look up
what speeds the conveyor was running for each line in the 1st query. Most of
the time it will only be one speed for each line in the 1st query, but it may
a few speeds. From their I will use
(DateDiff("s",[Query1].[StartTime],[Query1].[NextValue]) *(LineSpeed /60))*60
to determine feet traveled and then group by day.

Thanks,
Greg
Impulse MFG