If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum, totals?
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 |
#2
|
|||
|
|||
Sum, totals?
You shouldn't attempt to store calculated results. Query the existing
tables to calculate your total. |
#3
|
|||
|
|||
Sum, totals?
i tried putting in the criteria: =Sum([A]+[b])
but i get a "cannot have aggregate function in Where clause" |
#4
|
|||
|
|||
Sum, totals?
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 |
Thread Tools | |
Display Modes | |
|
|