Query design (Access 97)

Topic

New Reply

Hello,

I have created a query to extract some data and make a table with this data. I need to take some of the data in the new table and change the contents. An example: class code of ATC to class code of IAGeneral for all the records.

Is this possible in a query? I would like to perform this task all at one time.

Thanks,
Deborah

Reply | Quote

Replies

Welcome back to the Lounge! Yes you can do that with what is called an Update query. Design a query based on your new table that selects all of the records with class code = “ATC” and test it to make sure you are getting what you want. Then change the query to an Update query and in the update to cell for the class code field, put the string “IAGeneral” – that should do the task. Also you can easily modify it if you want to change other entries. Post back if this doesn’t quite make sense.

Reply | Quote

Is there a way to update the particular field from another table

Reply | Quote

If you want to update a field in TableA using a value from TableB, you must add TableB to the update query, and join it to TableA on an appropriate field (or fields). You can then set the Update To cell for the field from TableA to be updated to

![NameOfField]

with the actual names substituted.

Reply | Quote

If you want to update a field in TableA using a value from TableB, you must add TableB to the update query, and join it to TableA on an appropriate field (or fields). You can then set the Update To cell for the field from TableA to be updated to

![NameOfField]

with the actual names substituted.

Reply | Quote

Is there a way to update the particular field from another table

Reply | Quote