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?

Thanks.

MLimmer

Can you give the table structure of both tables and what kind of query you have so far?

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.