Putting fields from multiple tables into the same fields

[Peter Stone]

I have four Tables.

I want to select three fields (from every record) into three fields in a new
query or table. The three fields have identical names in each of the four
tables.

The resulting table will probably be used in a list box.

Which statement do I use?

SELECT INTO
FROM
ORDER BY ?

Thank You

Peter

 

[Allen Browne]

You can get Access to create the query statement for you:

1. Create a query using your table.

2. Drag the 3 fields into the output grid.

3. Change it to an Append query (Append on Query menu.) Supply the name of
the target table when Access asks.

4. Switch your query to SQL View (View menu.)
There's your SQL statement.

 

[Peter Stone]

Thanks for you help again Allen.

I hadn't thought of learning to construct my statemnts that way.

Peter (a fellow Aussie, but a long way from home)