Update Queries

[waholtmn]

I have a table that has many job classifications. I want to keep 4 and change all others to miscellaneous. How do I keep four and change the rest? I've been monkeying around with the update query feature but am unable to figure this one out. Please help.

Wayne

 

[CJ_London]

can you provide details of your table - are these job classifications in one column or many?

 

[waholtmn]

They job classifications are in a single column.

Thank you for assisting me!

 

[CJ_London]

OK so your query should look something like this:

UPDATE myTable SET JobClassification = "Misc"
WHERE JobClassification Not In ("Class1","Class2","Class3","Class4")

This assumes JobClassification is a text field, if a number then you can remove the double quotations