Hello,

is there a way to read the data in an access table, perform calculations on a field based on other fields then re-enter the field into the database?

Thanks,
MrLee

If you want to update data permanently, use update queries.
Look in Access Help for Update Queries or search this forum.

RV

It sounds like you need to use an update query. Open a new query in design view based on the table where the data is stored. Under Query in the menu bar, choose "Update Query". You can enter in selection criteria to determine which records to update, and there is a row for you to enter the new value.

You've now got answers going in two different forums on the same topic. Please only post a question once.