Appending Tables

  • Thread starter Thread starter jagstirling
  • Start date Start date
J

jagstirling

Can you help ? A simple one for you lot no doubt ....

I am new to Access ....

My probelm is ..... (using a simple example)

I have two tables ..... one has 4 boys names and one has 5 girl
names.

When I append the boys names list to the girls names list I end up wit
a list of 9 boys and girls names in the girls names table.

Brilliant ..... happy with that.

If I were to add a new boys name to the original boys name table an
run the append query again how could I ensure that ONLY THE NEW NAME I
ADDED and that I don't end up adding the original 4 names as well.

Many thanks in advance
 
Open the database window and go to queries. Click on New. Use the Find Unmatched
Query Wizard and create a query that finds records in the boys name table that
are not in the appended table. Then create an append query that appends the
records from the first query to the appended table.
 
Back
Top