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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,645
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,099,018
Messages
5,466,063
Members
406,462
Latest member
I10V3xl

This Week's Hot Topics

Top