Combine (Merge) Data from Two Access Tables

[mojo]

We have set up an Access database with tables x,y, & z where we would
like to have multiple people entering data into a table x. Each person
has an identical copy of the database on their PC's. When the person
is done entering the data into table x, we want them to e-mail their
database to one person who will combine the data from table x into a
single database.

What's the easiest method to combine the tables into a single table?

Thanks!

-Max

[Salad]

mojo wrote:

We have set up an Access database with tables x,y, & z where we would
like to have multiple people entering data into a table x. Each person
has an identical copy of the database on their PC's. When the person
is done entering the data into table x, we want them to e-mail their
database to one person who will combine the data from table x into a
single database.

What's the easiest method to combine the tables into a single table?

Thanks!

-Max

I'd add a field to TableX called Exported. It could be a boolean or a
date field. Maybe a date field would be better.

Then run a MakeTable query to select all records where Exported is Null
(or if they need to rerun it, for a date range). Maybe create a
database to hold the table that will be e-mailed to you.

They e-mail it to you. You save to a folder...maybe specific to the
user. Then run an append query from the folder of the user. You might
want to first create a query to select all records not in your
production table (so you stop an append process from being run multiple
times from the same table). Then run the append query from that list.