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) .