Combining Separate Tables into single Query for Report

  • Thread starter Thread starter sctvoice
  • Start date Start date
S

sctvoice

I have two separate databases that track different sporting evernts. I have
linked the primary table from one into the other, and I want create the
following:

A query that combines and sorts: Date; Time; Location from both tables
A calendar type report from the query above. The calendar report format has
already been created, so all I need is help with the query.

Thanks.

sct
 
sctvoice said:
I have two separate databases that track different sporting evernts. I have
linked the primary table from one into the other, and I want create the
following:

A query that combines and sorts: Date; Time; Location from both tables
A calendar type report from the query above. The calendar report format has
already been created, so all I need is help with the query.

Thanks.

sct

You could use a Make Table query to create a (temporary) copy of one of the
tables, and then an Append Query to add the records from the second table.

You can then sort and query the new table however you like.

David
 
Suggest you post relevant details of your Tables (including Key fields)and
how you relate the 2 Tables, especially, the linking fields.

It sound to me that you want a Union Query (check Access Help) but cannot be
sure unless I know your Table Structure.
 
Both tables contain numerous fields unique to each level of competition.
The fields that will be needed for my output are (in both tables):

Game Number (key field) | Date | Time | Location | Level | Home Team |
Opponent

Thanks,

sct
 
It sounds to me that you need a Union Query.

Check Access Help on Union Queries.
 
Back
Top