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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,649
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,926
Messages
5,471,560
Members
406,769
Latest member
GabrielleB

This Week's Hot Topics

Top