Combining Three Tables

[kdagostino]

I have three tables (Tour 1, Tour 2, and Tour 3) each with the same three
fields (Subject, Date, and Time).
There are different dates and times for each table.

How do I make one table with three fields that automatically inserts all
entries from each of the three tables from the corresponding field?

 

[tina]

if you want to continue to identify which tour each record belongs to,
create a field with the same fields (you can do a copy/paste of any one of
the tables in the db window, and select Structure Only option in the dialog
box). add an extra field to the new table; i'll call it TourNumber.

create an Append query to add the data from each table to the new table. in
each case, set the value to be appended to the TourNumber field to 1, 2, or
3 as appropriate.

hth

 

[kdagostino]

Thank You Very much.

if you want to continue to identify which tour each record belongs to,
create a field with the same fields (you can do a copy/paste of any one of
the tables in the db window, and select Structure Only option in the dialog
box). add an extra field to the new table; i'll call it TourNumber.

create an Append query to add the data from each table to the new table. in
each case, set the value to be appended to the TourNumber field to 1, 2, or
3 as appropriate.

hth