Summing other fields per record

[veder]

Is there a way to use a query to sum totals of several fields per record? In the db I have designed, I have 5 seperate fields for estimates from different departments. There is also a field for Total estimates. What I would like to do is have the Total Estimates field autocalculate the total sum of the other 5 estimate fields. Is this possible to do through a query? If so how? If not - is it possible at all?

Thanks!

 

[RV]

Is this possible to do through a query?

Yes.
Add a column to your query and totlaize your 5 columns.
Do not store calculated values in table.
So remove your Total Estimates column from your table.

RV