Update Query not updating all records

[ijswalker]

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

 

[ijswalker]

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

Sorry

Ian