working beween records in tables

[JoeJ]

I need to create a report from a table that collects the time that a
manufactured item is ready for delivery. One item I need to add to the
report is the time differential of each manufactured item sent to a specific
location. For example, Widget 1 has a ID of 1, and production time of 10:00
am. Widget 2 has an ID of 2, and a production time of 10:03. Widget 3 has
an ID of 3, and a production time of 10:07. I need a report that based on
this items falling in sequence of ID can calculate the time differential is
0:07 (Minutes). I am fairly knowledgable with access, but this concept is
stumping me. (I don't need help with report formating or grouping, just
getting these pieces of information to calculate.)

Thanks

 

[Allen Browne]

So you want to read the time value from another record in the same table,
and then calculate the difference in minutes?

Use a subquery to read the other record. Details in:
Subquery Basics: Get the value in another record
at:
http://allenbrowne.com/subquery-01.html#AnotherRecord

Then use DateDiff("n", ...) to get the difference in minutes. Details in:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

 

[JoeJ]

Thanks Allen,

I think this is working like I need it.

Joe