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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing multiple pages on one individual from an Access Report 1
Errors in Report total fields 19
Reports that sift records from different tables 0
Creating a report from a table with most info blank 3
Excel Concatenate Form Name to Parse for function 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
total number of checkboxes checked, Access form 1
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1

Back
Top