Update field for all records at once

[thart21]

I have a table "volumes" with the following fields:
product, year and one field for each month of the year. I update the data in this table monthly. From that table I calculate a total volume for each "project" through an After Update event on my "Cut In Month" field on my form
Right now, when I update my volumes in the table I have to go through and trigger the After Update event on each and every record to get the calculated field to represent the updated volumes from the table.

I would like to have one button on my form that does this all at once. Is this possible without binding it to the table?

Thanks,

Toni

 

[neileg]

An update query should do this for you. However, your data is not normalised. You should have one record per month not one field per month.

 

[thart21]

Thanks, I will try that. My table is normalized, the form is not based on that table, it is just a data table that is used to create the other queries to get to the total volumes for one field on the form.

Toni

 

[KeithG]

I would agree with Neileg about the normalization.

 

[neileg]

Thanks, I will try that. My table is normalized, the form is not based on that table, it is just a data table that is used to create the other queries to get to the total volumes for one field on the form. Toni

A table is a table. What is 'just a data table'?