Nov 10 2004, 05:39 PM
I am trying to accumulate (Sum) a number field in a table from many records in another table. I am trying to create a update query to udate one record in Table 2 with the accumulated records from Table 1.
Table 1 has three records.
Voter count = 10
Voter count = 5
Voter count = 20
Table 2 has one record.
Voter Count = 25
I am unable to figure out how to do this. Can anyone help?
Nov 10 2004, 08:40 PM
Can you give the table structure of both tables and what kind of query you have so far?
Nov 11 2004, 12:51 PM
I was just rereading your question. Why do you need to store calculated sum in another table. Normally you should not do this, because it uses up space and you can always run the calculation to get the answer at anytime in any form, report, and query.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here