access tables, modify, then re-upload data

MrLee

Registered User.
Local time
Today, 20:57
Joined
May 1, 2002
Messages
12
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.
 

Users who are viewing this thread

Back
Top Bottom