I've got a d/b with 4 tables in it.
I want to make a single table of this data - which is all the same as it is
the records of activity for each of 4 months
How do I do this?

TIA

Build an append query to take the records from each of the tables and add
them to one table. I would also add a date field as I did this so you will
know where the data came from. Once you have added all the records to one
table, delete the other three tables.


--
Rick B



"Alan Davies" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I've got a d/b with 4 tables in it.
> I want to make a single table of this data - which is all the same as it
> is
> the records of activity for each of 4 months
> How do I do this?
>
> TIA
>
>

Need a bit more information. Are you tables linked in a one-to-one
relationship? If not, how are they related to each other?

"Alan Davies" wrote:

> I've got a d/b with 4 tables in it.
> I want to make a single table of this data - which is all the same as it is
> the records of activity for each of 4 months
> How do I do this?
>
> TIA
>
>
>