Subtracting fields in a table

  • Thread starter Thread starter Steve G
  • Start date Start date
S

Steve G

Hi,

I would like some help seting up the input mask for a
field in a table to do subtraction. I have a field that is
updated daily (call "MeterReading"), what I would like the
field with the subtraction format is to take the
difference of today's data with yesterday's data and
record it in the table. Is this possible??? Any assistance
to set this up would get great!

Thanks,
Steve
 
Steve,

Do you use a form for this input? Also are your
readings stored in the table with a date stamp?
 
I would like some help seting up the input mask for a
field in a table to do subtraction. I have a field that is
updated daily (call "MeterReading"), what I would like the
field with the subtraction format is to take the
difference of today's data with yesterday's data and
record it in the table. Is this possible???
Click to expand...

First of all: no it's not possible with an input mask. No chance.

Second: it would be possible to do this on a form with a simple unbound
textbox that would carry out the calculation for you.

Third: it is probably unnecessary if you have set up the tables right, as
you should be able to calculate balances in a query. It is certainly a bad
idea to have duplications of data like YesterdaysReading, TodaysReading,
and TodaysUse.

Hope that helps


Tim F
 
Back
Top