Printing Detail Records Twice

[David Spengler]

I'm building a database that is a schedule of high school basketball games,
so the basic fields in the table "Games" are game date, home team number,
home team name, visitors team number, and visitors team name. Each game is
entered into the table only one time (NOT once for the home team and once
for the visitors team).

I want to be able to print schedules for all teams on one report, therefore,
each game must be printed TWICE, once on the home team schedule, and once on
the visitors team schedule. How do I write a query or use any other method
to make each game print twice--once on each schedule, home and visitors?

Thanks.

Dave Spengler

 

[Duane Hookom]

Create a union query that selects from the same table twice but reverses the
home and away fields.