Update or Append

[pwicr]

I have one table of of 300 records and another of 200

If I do an "Append" query, will I be able to add the extra 100 records to table 200 to make it match the 300 without duplicating information?

 

[Beetle]

The first question would be why do need two different tables with the same set of data?

The second question would be is there some field(s) that can be used to reliably identify the "extra 100" separate from the other 200?

 

[pwicr]

I am moving information from one table to another to make the table appropriate. the old table wasn't set up correctly. I have now taken THAT table and made other tables that are based on the first one. The old one is still live until I get the new one finished but I have already imported 9785 records into the new table and need to append it to have 9808 like the old one.

 

[Beetle]

OK, so what's the answer to the second question from #2?

 

[pwicr]

I did an unmatch query, then did an append from there to add only the records that don't match.

Thanks!