Can I do this with an update query?

[BillyDo]

Hi all

I want to build an update query which will update data in TableA

I want the user to enter a parameter to look for a value in FieldA. If that value is found then I want the text in FieldB to be automatically updated with a numeric value from a 2nd user entered parameter (for example "500").

Hope someone can help with this

Many thanks

 

[bob fitz]

Hi

You may like to try this:

UPDATE TableA SET TableA.FieldB = [Enter Update Value]
WHERE (((TableA.FieldA)=[Enter Criteria]));