calculated field in a query

[Adeola]

I Have some calculated fields in a query and want to update it in the table .So,is there anyway to store these fields.Otherwise can i store this Query data every month in database so that when i re-run the query the previous month data will not be affected.
can anybody help me out.

 

[namliam]

Yes you can make it an update query which can update columns in your table, however calculated fields are only VERY RARELY stored in tables... The 99.99% rule of thumb is not NOT store calculated values