By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,073 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,073 IT Pros & Developers. It's quick & easy.

Refer to the Previous Record

P: n/a
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

Mar 9 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Mar 9 '06 #2

P: n/a
Thanks Allen, it works!!!

Mar 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.