If-then statement on access

[Guest]

If "State" column says NJ, and "ransfer" column says T, need to change T to
E. (New to Access, please help)

 

[Douglas J. Steele]

The SQL for the query would look something like:

UPDATE MyTable
SET ransfer = "E"
WHERE State = "NJ" AND ransfer = "T"

 

[Guest]

Thanks I'll try it!

The SQL for the query would look something like:

UPDATE MyTable
SET ransfer = "E"
WHERE State = "NJ" AND ransfer = "T"