Update query - more than 1 column???

[Guest]

hi Guys,

Can you update more than one table column at a time in an update query? It
doesn;t work for me and I don;t know if I am doing something wrong or you
just can't do it??? Thanks.

ex.
UPDATE tblImportHold SET Fund = "MFS" AND Report_Quarter = "3rd" AND
Report_Year = "2004" WITH OWNERACCESS OPTION

 

[Guest]

Nevermind, I figured it out.

UPDATE tblImportHold SET Fund = "MFS", Report_Quarter = "3rd", Report_Year =
"2004" WITH OWNERACCESS OPTION;

 

[Tom Ellison]

hi Guys,

Can you update more than one table column at a time in an update query? It
doesn;t work for me and I don;t know if I am doing something wrong or you
just can't do it??? Thanks.

ex.
UPDATE tblImportHold SET Fund = "MFS" AND Report_Quarter = "3rd" AND
Report_Year = "2004" WITH OWNERACCESS OPTION

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts