update query

[ManvinderKaur]

hi I am trying to run update query joining one table and query but that give always weeor like it should be an update query

UPDATE tblMapSheetCode Inner Join qryUpdateMapSheetCode on tblMapSheetCode.CODE  = qryUpdateMapSheetCode.MapCode
SET tblMapSheetCode.AlphaCount =  qryUpdateMapSheetCode.ACount;

[Datagopherdan]

You cannot update a table with query information. You would have to join 2 tables together in order to update.

[ManvinderKaur]

Thanks , I have figured out i can not then i have done using VBA...

[Datagopherdan]

YW. Glad you got it figured out.