Hi,

I have an update query in my Access 2003 database. I want to update three columns based on the Project_Number. However, the query will not update all of my records even though there is info to update from. I have 390 records to update but it will only update 350 of them. Has anyone came across issue like this before.

Thanks

UPDATE tblProjectStatus INNER JOIN BASE_PROJECTION_DATA
ON tblProjectStatus.PROJECT_NUMBER = BASE_PROJECTION_DATA.[PROJECT_#]
SET
BASE_PROJECTION_DATA.CO = tblProjectStatus.CO,
BASE_PROJECTION_DATA.CO_NAME = tblProjectStatus.COMPANY_NAME,
BASE_PROJECTION_DATA.PROJECT_STATUS = tblProjectStatus.PROJECT_STATUS;


Cheers

Ian

I have figured it out. I am referring to the wrong table

Sorry

Ian