criteria for an update query

  • Thread starter Thread starter aly
  • Start date Start date
A

aly

Here's my problem, I'm trying to create an update query in
Access 97 and I don't know how to write the proper
expression for the criteria. I want the query to change
the data from a field in a table from the description of a
code to the code itself (there are multiple codes and
descriptions). How do I write a expression to make this
change? I have changed the form for future data, I just
need the existing data to change without having to
manually change it. Thanks!
 
1-the descriptions have to exactly match
2-create a new field in the destination table for the code
3-link the 2 tables in an update query using the code
description
4-make the "Update To" of the new field =[code field] in
the code table. use the square brackets too.
5-run it
6-check the contents, if OK, proceed
7-delete the old description field
8-rename the code field to what the description field used
to be
 
Here's another question for you. Since I have
approximately 200 Defect Codes and Descriptions
(example code and description: F15 - Phosphor Distribution)
will I have to run seperate queries for every defect code
or did I misunderstand your instructions?
 
Back
Top