How do I make a text box display a value from the previous record

[Jim L.]

I am building an inventory database. Volumes are entered daily as a record.
I need the "End" volume from the last record (yesterdays volume) be
displayed as the "Start" volume of the current record. How can I write this
expression in a query, or as a text box on a form?

 

[Tom Wickerath]

Hi Jim,

Try this odometer example. Disregard the "ACC2000:" in the title:

ACC2000: Referring to a Field in the Previous Record or Next Record
http://support.microsoft.com/?id=210504


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Jim L.]

Thanks Tom, it worked perfect. Now that I have the values, can I subtract
the previous entry from the current entry to get an "amount used" value, and
can I write this amount to the table since the control source is an
expression instead of a field name? Sorry for all the questions, but I'm a
beginner whose pulling my hair out!!
Thanks again.