Calculations in tables

[frustratedwithaccess]

Hello All,



I need to convert calculated field values in a table to fixed values. Is there an easy way to do this?

Cheers!

[thebigthing313]

I would advise against storing calculated fields in tables in the first place. Nonetheless, the easiest way to do this is an Update Query. To help you further, we'd need to know about the structure of the table.

[frustratedwithaccess]

Thanks for tip. I managed to figure this out with Update Query.

[thebigthing313]

No problem. If you have any other questions, feel free to ask. If not, don't forget to mark the thread as solved.