List fields data from two tables.

[Rlittle]

I have a database that has two table (game1) and (game2), both tables have
id, formation, play, attempts, and yards.

I want to create a query that will list all of the records from both of the
tables in the formation field.

Is it possible?

Thanks,
Rlittle

 

[Van T. Dinh]

Check Access Help on Union Queries.