SUM TOTAL

[cornishteeth]

I am new to Access and trying to figure out somehthing that is probably a simple thing. On a form, I have 4 inputs that denote downtime for a machine that I am running (DT SETUP, DT MAINT, DT ELEC, DT REG). I want to tally the total, show it on the form, and also put the amount in my table under TOTAL DOWNTIME for later "querying." The problem that I am having is that I can get it to total on the form using the formula below. The formula is placed in the Control Source of my TOTAL DOWNTIME info. Once it tallies the total, why can I get it to go to the table under TOTAL DOWNTIME. What am I missing?

=Sum([DT SETUP]+[DT MAINT]+[DT ELEC]+[DT REG])

V/R
Cornish Teeth

 

[anvil19]

Hi cornishteeth

What you are missing is : Where would the result go in your table? Into the first row with a value that complies to your search criteria or the last row??

The only place that you can show a Sum_Total value is in a query. The query would display the records that represent a query value grouped by a date, an amount of time between dates etc, etc. and your Sum total would go into that record.

You could then create a table, or update a table with that single record with the grouped values and the total you want.

Any help??

anvil19