Update query is not working - stumped

norwoodkd2001

New Member
Joined
Jun 30, 2015
Messages
10
I have a table called Score which has records of individuals scores for a certain requirement presented by a vendor. The list of requirements is in another Table called Requirements. In the Score table we have entered a Requirement ID that corresponds to the requirement in the Requirements table.

Both tables have the Requirement ID which is what I am using to select the correct record.

I am running this update query but nothing is updating in the Score.Requirement field. What am I doing wrong?:confused:

UPDATE ScoreINNER JOIN Requirements ON Score.[Requirement ID] = Requirements.[Requirement ID]
SET Score.Requirement = [Requirements]![Requirement];
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,628
Office Version
2013
Platform
Windows
Normally the thing to do is inspect the results with select and see what you are getting on the joins:

select *
FROM
Score INNER JOIN Requirements
ON Score.[Requirement ID] = Requirements.[Requirement ID] ;
 
Last edited:

norwoodkd2001

New Member
Joined
Jun 30, 2015
Messages
10
Thank you! I realized after looking at all the columns my import from Excel for the Requirements table didn't work correctly. I fixed that problem and all is well.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,726
Messages
5,446,153
Members
405,386
Latest member
xcookiemonster64

This Week's Hot Topics

Top