Update Query returning more records than table it is updating

[frustratedwithaccess]

Hello All,



I am attempting to run an "UPDATE" query however it is returning more records than in the table I am trying to update. Any suggestions as to where I might start in solving this issue?

Thanks!

[orange]

Before doing an Update, use a SELECT query that is ReadOnly and make sure you are selecting the proper records.

Show us your query SQL.

[frustratedwithaccess]

Thanks for the response. I will try the SELECT query that is ReadOnly

Re SQL

UPDATE

TABLE1

AS

TABLE1

INNER JOIN

TABLE2

ON

(Table1.SamDate = Table2.SamDate) AND

(Table1.ProjectNumber = Table2.ProjectNumber)

SET

Table1.Flag1 = Table2.Flag1

WHERE

Table1.Flag1 IS NULL;


The column named Flag1 in Table1 has many records that are null (empty cell) and other records that have data. I am attempting to update these empty records with data from Table2.

[orange]

Try this query in your query grid SQL view.

SELECT "Flag1 " & NZ(t1.Flag,"NULL") &  "  Flag2  " & t2.Flag1 & "   " & t1.ProjectNumber & "  "  & t1.SamDate
FROM Table1 as T1 inner join Table2 as T2 
ON (T1.SamDate = T2.SamDate) AND
(T1.ProjectNumber = T2.ProjectNumber)

[frustratedwithaccess]

Hi Orange.

Thank you for your help, and please excuse my delayed response. I didn't end up having to try this query. I eventually found some issues with the tables I was using to populate my main table with.

Again, thanks for the time. It is much appreciated.