If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Appending a table by adding only records who are not duplicates
I am designing a database program for a Fantasy hockey league. table A gets
Players current stats from an excel spredsheet it is linked to. Table B is to be updated with the current stats. Now updating existing records I have no issues with. If a player is new or added, I need him to also be added to table B. Here is the kicker, Table B has one more column for status (Free Agent, or what team owns that player). I don't want this information to change. I have tried to use an append query but that way not only adds the new guy to table B, it adds every other guy again. A make table query would be perfect, but it will eliminate that additional status column. Is there a way to get an append query to do more of a differential append that will append only those players that are currently not on Table B? Thanks Adam |
Thread Tools | |
Display Modes | |
|
|