Sum, totals?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IF I have 2 table (A & B) and I want to add them to the quanity of table C. How would I do that. But I want table C to be a running total

So if table C = 10

and I add 5 to table A and 10 to Table

Then Table C updates to 115
 
You shouldn't attempt to store calculated results. Query the existing
tables to calculate your total.
 
IF I have 2 table (A & B) and I want to add them to the quanity of table C. How would I do that. But I want table C to be a running total.

So if table C = 100

and I add 5 to table A and 10 to Table B

Then Table C updates to 115
Click to expand...

A Table IS NOT A NUMBER. It can have millions of records, each with up
to 255 fields. "Add them to the quantity" is a meaningless term, when
it comes to tables! What is the sum of _Moby Dick_ and _Leaves of
Grass_?

Secondly, a Running Total should essentially *never* be stored in a
Table.

I think what you want is a Totals Query, but please explain the field
structure of these tables, what they represent in the real world, and
what you're trying to accomplish.
 
Back
Top