Update Question

[sha123]

I have a table with a Anonymous field and a region field

In the Anonymous field I have three values = "10" "30" "60".That only apears once in the table/Form.

I need a query that will write a value = "WC" into the region field till it gets to the the "30" value.
Is it possible in any way to do this???

 

[jksmi]

hi, you dont say if you want to change for any other values so simplest is...

if anon is numeric then try

UPDATE TBL_ANON SET TBL_ANON.REGION = "WC"
WHERE TBL_ANON.ANON<30;

else try...

UPDATE TBL_ANON SET TBL_ANON.REGION = "WC"
WHERE TBL_ANON.ANON='10';

if you want to test logical operators then you could use iif or case (see help files for syntax)

Hope this helps, Jamie