Info not going from form to table

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I am taking over a database that was set up prior to me.
In the form there is different times being entered in.
They then have a formula that adds up the different time
each person has and the total is shown on the form. This
works. When I go to the table all of the individual times
are there but the total comes out as "0".
 
I am taking over a database that was set up prior to me.
In the form there is different times being entered in.
They then have a formula that adds up the different time
each person has and the total is shown on the form. This
works. When I go to the table all of the individual times
are there but the total comes out as "0".
Click to expand...

The other person has correctly designed this aspect of Access.

All you need do, whenever you need the totals is total them up as you
already are. The total ought not to be saved in the table.
You are using Access, a relational database, not Excel, a spreadsheet.
That Total field need not even be in the table.
 
Back
Top