Recent content by stuwalsall

I opted to try the Update query as it was quicker. Because the data flies into an otherwise empty list, it's easy to just look at it and see if anything inappropriate from the master table turned up in it, otherwise I'd have taken the duplicate option, just to play careful. Thanks tho guys...

It worked! I just tested it on a backup I have and it threw in 20 records into a list of 150. This is going to save me a lot of time in future. Thanks. :D Stu

Both tables have exactly the same fields, just the master table has 15000 complete records in it, and the "slave" has 200 incomplete records. The primary key field, autonumber field, is called ID. The other fields in slave table with data already entered are called Company, Telephone, Fax...

The master table has 15000 records of names, emails, etc. Every day I get a list of just the names and have to spend the day phoning people and chasing data to get the email addresses and other missing data. At the end of every day the list is imported into a new Access table from Excel and...

I have a table in Access called contacts which has a whole bunch of names, email addresses, etc. Everyday I have to create a new table with contacts names and match them to the master table. Obviously there has to be an easier way with a query or something, maybe an append query? The list I...