Access 2000 Query Question

  • Thread starter Thread starter EAB1977
  • Start date Start date
E

EAB1977

Hello everyone,

Is it possible to change a record in a select query without having to
use a update query?

Example:

Product Line Testing Code
1 1
1 2
1 3

What I want is if the testing code = 3, can I change the label to a 2
instead of a 1 wirhout using a update query?
 
If you just want to display the value, you can do it in a SELECT query:

SELECT IIf([Testing Code]=2, 2, [Product Line]) AS Product Line,
[Testing Code]
FROM YourTableName;


But, if you want to permanently change the value of Product Line in the
table, then you will need to use an update query.
 
Back
Top