Find and replace field

[ShagNasty]

I need a translation -- How would this be handled (written) in Access"ise"?
Replace FieldA with "54321" if FieldB = "001234" and FieldA = "00000"

many thanks in advanced....
ShagNasty
Office97 WinXP

 

[fredg]

I need a translation -- How would this be handled (written) in Access"ise"?
Replace FieldA with "54321" if FieldB = "001234" and FieldA = "00000"

many thanks in advanced....
ShagNasty
Office97 WinXP

If the data is exactly as you state it above, you can run an Update
query.

Update YourTable Set YourTable.[FieldA] = "54321" Where
YourTable.[FieldA] = "00000" and YourTable.[FieldB] = "001234"

Note that FieldA and FieldB must both be text datatypes, as indicated
with the quotes around the values.