Automatic totals

[Ravi Kumar]

hello all,
I have a form called usage of gauges,
In it i will enter the number of times i have used the gauge today ,
but this must be added to the table named same as my form & store the new value.
for example: if in my form i enter position = 36,
suppose the column field contained 24 earlier in my table, it should save with 60 now .
how to achieve this??

 

[pbaldy]

As a general rule most of us would not try to maintain the total value. We would store the transactions (24 and 36 in your example) and simply sum them with a query or DSum() as needed for forms/reports.