Appending Tables

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
 
P

PC Datasheet

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
If/then-type situation. IF in this field, THEN THIS in that field? 3
dynamically sorted list with duplicates 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Merging from an Excel file with graphics 1
List of Tables 1
Need help modifying code 0
Space at end of multi page list to accommodate new entries 1

Top