entering daily data

[Guest]

I have a form to enter data, using data collected by operator at end of each
day. Example data collected: Meter #1 today's reading, Meter #2 today's
reading, etc...
I want the operator to have the lastest reading (yesterday's reading) when
today's reading is inputed into form. I also want the form to display the
total, which would be today's reading - yesterday's reading.

At the end of each day, the operator would pull up this form, select today's
reading field, and yesterday's reading would be displayed in one column. He
would enter today's reading, and after hitting enter (or tab) the total would
display.

I will need this info kept (in METERtable) for use at end of month, where I
can get a total for Meter #1, Meter #2, etc... for a report. But that is
another project. For now I just need to know the best way to get the amounts
saved into a table.

 

[Guest]

Seems to me you need a MeterReadings table...

What is our table and field setup?

Steve

 

[Guest]

I won't list all items from table (METERtable) since they are all basically
the same layout. I have 3 number fields titled "yesterday#1", "today#1", and
"total#1" (same for 4 other meters) My form was created from this table.

In the past, on paper logsheets, the operator would fill in all fields
manually. I would like for the operator to type in just "today's" reading
for each type of meter.