Make a text box display a value from the previous record

[Jim L.]

I am working on an inventory database in Access 2003. Each day's values are
a seperate record in the table. I need a text box on the form to display the
previous day's amount to compare to the amount the user is entering for
today. Also need another box to display the difference between the values
for the current day and the previous day. I am a beginner, so please go easy
on me!
Thanks
Jim

 

[Wayne-I-M]

Hi Jim

I think most people here will need a little more information.
Each day do you enter one figure eg 123
or do you have a set of numbers eg 123 567 89 and you want the total / the
last figure entered / the average, etc

eg. If you just enter a single amount and you want to refer to the previous
days figure then you would use a DateAdd
somethink that include DateAdd("d", -1,Date()) or if you have a continous
form you could do it even simpler ith a Running Sum or to get the last figure
entered you would use DMax, etc, etc

So can you supply some more info

 

[Jim L.]

Wayne,
Each day, the user will enter several values (Water level, product inches,
gallons, etc.) in the fuel inventory form. What I want to be displayed on
the form they are entering on is the "gallon" reading from the previous day,
so when they enter today's numbers, they can see right away if they wrote
something down wrong, or transposed numbers. From there, once they enter the
gallon amount for the day, an "amount used" box for the day would display
showing the difference between yesterday's readings and todays readings. I
also want to do the same thing with dispenser readings (pump odometer). Once
both values are entered (gallons & odometers), both "amount used" totals will
be compared (difference) to show a gain/loss in inventory.
I'm sure this is very convoluted. I'm doing it all in Excel now, but it
would be nice to get all of my end of month reports to be completed with the
push of a button. Also, other users are really messing things up involving
all of the formatted cells.

Jim