Update query - more than 1 column???

M

MaBell

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
 
M

MaBell

Nevermind, I figured it out.

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

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

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