Find and replace field

  • Thread starter Thread starter ShagNasty
  • Start date Start date
S

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
 
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
Click to expand...

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.
 
Back
Top