Refer to the Previous Record

[imagabo]

I have a MS ACCESS table that contains The Production End time for each
pallet of cases but the start time for the finished product is really
the end time of the previous Item produced, and now I want to be able
to get the Total Run Time for that Item.
The table looks like this:
Item Number End Time
00123 07:30
01234 08:30
The Run time for 01234 is equal to 60 Minutes.
I will appreciate a lot if someone takes some time to help me on this.
Thanks

[Allen Browne]

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/kb/210504/en-us

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"imagabo" <im*****@hotmail.com> wrote in message
news:11**********************@j52g2000cwj.googlegr oups.com...

I have a MS ACCESS table that contains The Production End time for each
pallet of cases but the start time for the finished product is really
the end time of the previous Item produced, and now I want to be able
to get the Total Run Time for that Item.
The table looks like this:
Item Number End Time
00123 07:30
01234 08:30
The Run time for 01234 is equal to 60 Minutes.
I will appreciate a lot if someone takes some time to help me on this.
Thanks

[imagabo]

Thanks Allen, it works!!!