The reason I want to store the Total is because I am using that information in a mail merge document in Word. Which is also the reason I don't want to store multiple years data in one table.
[This message has been edited by Pack (edited 05-01-2002).]
I entered the control source (=[Footage]*[Rate])
and it is calculating it in the form, but is not entering the result in the Table.
I am not using any queries for this. The Rate will not change because I will be creating a seperate table each year.
I have created a form based on my table. I want to be able to enter values in the form for a Rate and Footage. I have a expression written to then calculate the Total (=Rate*Footage). How can I update the Total field in the table?