Combine tables in query

[natalievl]

Hi everyone,

I hope someone can help me.

I have a few tables with the same structure but different data.

I need to list them in a query or a table query that will automatically update.

The tables are not linked.

ray:

 

[Ziggy]

You can create a join/union query with 2 or more tables, this way you can link the data for use in reports/forms

or you can create an append query to update one table from another. Search this sight or help file for these topics.

Ziggy

 

[natalievl]

I need the matching fields to appear in the same field without any matching data.

Can you help any further?

 

[dk]

Hi,

Try clicking Insert, Query and choose Design View. Once in design view choose Query, SQL Specific, Union. Then type something like this:-

SELECT Table1.*

UNION ALL

SELECT Table2.*

Does that do what you want? Obviously you'll need to substitute Table1 and Table2 with the names of your tables.

 

[Ziggy]

Hi Natalie,

Can you provide more details, and maybe the fields for the tables, (unless dk has your answer).

Ziggy