GOING INSANE: Multiple Replace criteria in Multiple Fields 1

[IanGlinka]

I'm trying to write 1 update query (as opposed to 60) that will look through approx 20 fields of a single table and replace the cell contents according to multiple replace criteria.

If the contents of the cell are 'N' - the cell must be updated to a null value.

If the contents of the cell are 'V' - the cell must be updated to a 'P' value.

If the contents of the cell are 'A' - the cell must be updated to an 'M' value.

I know I can do this if I write three separate update queries per field (one looking for 'N' and updating the value to null, one looking for 'V' and updating the value to 'P', and one looking for 'A' and updating the value to 'M'), but that would result in 60 queries.

Slowly losing my mind...

Ian

 

[PHV]

Take a look at the switch function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[IanGlinka]

Wow... it's not the fastest thing in the world, but it gets the job done!!!

Thanks!