On Tue, 27 Apr 2004 06:51:03 -0700, "Cory"
wrote:

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

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.


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public