Query difference in Time from Multiple Records

[ewong1]

I currently have a table with the following fields:

dtmDate intPress intCycle intProgram intLot ysnAxial dtmFStart dtmFFinish dtmPStart dtmPFinish dtmDStart dtmDFinish

How might I go about querying the difference between dtmDFinish and dtmFStart for multiple records?

EX:

09/07/05-1-1-1-5681-NO-12:30-1:00-1:30-2:00-2:30-3:00
09/07/05-1-1-1-5681-NO-3:30-4:00-4:30-5:00-5:30-6:00
09/07/05-1-1-1-5681-NO-6:15-6:45-7:30-8:00-10:30-11:00

Would return two results: difference for 3:30-3:00 = 30 minutes and difference for 6:15-6:00 = 15 minutes

Thanks for your help!

 

[ewong1]

I understand what you are saying, but I am not sure how I might be able to accomplish what you are suggesting. The way it is currently set up, I really just need to know the difference between end times and start times on records pertaining to the same date and press #. Is it possible?

 

[ewong1]

Now that you've convinced me that an autonumber is required, I've added it to my table as the primary key. Now what do I do?

 

[ewong1]

Wheres the link?