The search key was not found in any record

[barra47]

I am trying to do a simple update query based on records match between 2 tables
but when i run the qry I get the error nessage

"The search key was not found in any record"



UPDATE [labour detail admin copy] INNER JOIN [Temp tbl] ON [labour detail admin copy].LD_ID = [Temp tbl].[ID Number] SET [labour detail admin copy].Scope = [Temp tbl]![Scope]
WHERE ((([labour detail admin copy].LD_ID)=[Temp tbl]![ID Number]));


Both join fields are Primary key fields

Can abyone help with this problem

Thanks in advance.

 

[dhookom]

I'm not sure why you have a WHERE clause since the JOIN seems to already perform this. Can you share any primary and foreign key fields?

Duane
Hook'D on Access
MS Access MVP

 

[randy700]

I'd try running the query without the WHERE clause.

Randy

 

[smedvid]

Here is the way I did it before.... (from dbForums)

UPDATE tblData
SET tblData.Total = SUM(P.Amount)
FROM TableP P, tblData D
WHERE P.Acct = D.Acct
AND P.Type = 'PUR'
GROUP BY D.Acct


Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[barra47]

Thank you all for your replies

I found the problem was not in my query. Some of the records were corrupt the records were corrupt.