update field based on the contents of three additional fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table imported from MS Excel which contains data in [F6] which I
want to appear in [F11] if a value exists in [F1] and [F2]. How do I go
about this?
 
Can you use an update query?

UPDATE YourTable
SET [F11] = [F6]
WHERE [F1] Is Not Null and [F2] is Not Null
 
I tried the update query for the 'AnalysisImport' table as
you noted below and received 144 blank records for the
field [F11]. I'd like to get it populated if [F5]
= "Engine (1/2/3):". But when I add that into the WHERE
clause I get one blank record in [F11]. Help...
-----Original Message-----
Can you use an update query?

UPDATE YourTable
SET [F11] = [F6]
WHERE [F1] Is Not Null and [F2] is Not Null


I have a table imported from MS Excel which contains data in [F6] which I
want to appear in [F11] if a value exists in [F1] and [F2]. How do I go
about this?
Click to expand...
.
Click to expand...
 
Back
Top