Update-Replace Query (97 – 2)

Topic

New Reply

Greetings,

I have a field called EOE (Element of Expense). It’s a text field, length 4.

I need an update query that will change all EOE 1198, 1199, 1250 to 1198.

So…if the EOE Is Not 1198 Or 1199 Or 1250, change the EOE to 1198.

In this example, there are 750 records…of which 453 ARE NOT 1198, 1199, or 1250. Its these 453 records that I want to change to 1198.

Thanks in advance !!

Reply | Quote

Replies

Create a new query, change it to an update query, include the field EOE, put the value “1198” in the update line, and in the criteria line put :

Not in (“1198”, “1199”, “1250”)

Reply | Quote