more info on query

[hendrikbez]

I have this code, it is working, but I need more info to be giving back to user

I am updating table TAPES from an import table RECIEVED every day.

UPDATE Recieved INNER JOIN Tapes ON Recieved.StickerNumber = Tapes.StickerNumber SET Tapes.DateReturn = [Recieved].[DateReturn], Tapes.RecievedBack = [Recieved].[RecievedBack];

When I rub this I need it to show all of the StickerNumber that have been done and that have not be done.

Now when I run this qury and the usewr did not put in the stckenumber in the databse I cannot see if it is then updated as it is not here.

eg.

PTAV00071761 was done as it is in the database table
PTAV00072174 was not done, it was not in the database table.
PTAV00072178 was done as it is in the database table
PTAV00072181 was done as it is in the database table

si if I can get it so how each one with how many in that pta number (can be 1 - 4) and if it was done or not done

[CJ_London]

you can run this query before you run your update query to find out what will or won't get updated based on the stickernumber existing in the tapes table

SELECT Received.StickerNumber, "Will " & iif(Tapes.StickerNumber is null, "not ","") & "be done" as success
FROM Recieved LEFT JOIN Tapes ON Recieved.StickerNumber = Tapes.StickerNumber

[hendrikbez]

Hi Ajax, Thank you

Did run it, bit get a box with "enter parameter value' on
Received.StickerNumber

[CJ_London]

check the spelling of Received - I spelt it correctly

[hendrikbez]

Ajax
Thank you, I should have see that I spelled the word wrong, it is working now