Mergiing Access

L

Loretta Jean

The last sentence I typed was misworded. Here are the
steps I'd use if you have to use separate databases:

1. APPEND the records from each database to the master
dbase.
2. DELETE the records from each database after they're
appended so the next time around the separate databases
only include the current entries that haven't been
appended.
 

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

Copy previous record into form field 0
Merging from an Excel file with graphics 1
Page numbering with Merged Document and IF statements 1
How do I consolidate multiple access databases into one? 9
Importing Excel Data and Comparing to Existing Data Records 4
Access Database 3
How do I insert the name of a table into my "master" table? 4
How do I clear a form? 0

Top