Query to append table

[hendrikbez]

I Have a table (tapes) with a lot of data in in, it have about 10 columns.
I am making a new table (Recieved) with data that has changed in it (dateback) so I am using only 3 columns.



I am trying to append/change this 3 columns into the tapes table, it is running, but it makes new data rows, and not change the ones that is in it..

And in one colum I have name (booknumber) this booknumber can be in more than 1 row( about 15 at most), so how can I if I run the query, that it keeps the columns that has no change in them the same and only change the 3columns that I want to and how do I let it change all the same bookumber) .

[June7]

Have to JOIN the tables on key fields. How are tables related? Is booknumber in both tables?

Why do you need these 3 columns in tapes?

If you want to provide db for analysis, follow instructions at bottom of my post.

[hendrikbez]

Have to JOIN the tables on key fields. How are tables related? Is booknumber in both tables?

Why do you need these 3 columns in tapes?

If you want to provide db for analysis, follow instructions at bottom of my post.

Here is the table in zip format

1. Tapes (Table) is my main table where all the info must go to. This table have 13 columns in it, and I want to update some data in it.
2. Recieved (Table) is one that I want to import(it is working) every day(data change evry day). Only 3 columns in this table (StickerNumber, DateReturn and RecievedBack).
3. In tapes(Table) I only need to add(change info) to the (DateReturn and RecievedBack) columns as they are empty. I have added StickerNumber to let access know only those must be updated.
4. YOu can see that there is more than on row with the same StickerNumber.

[June7]

Yes, rows with same sticker number will receive the same data.

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


NOTE: You have used an incorrect spelling of Received

[hendrikbez]

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

June7, I have try to put this top info into theUpdate to: in the query, but it gives me invalid syntex, so I am not sure if it is in the correct place for it.

[June7]

Copy/paste my query statement into SQLView of a new query. Then switch to Design view.

[hendrikbez]

June7

Thank you I have got i to work.