not sure how to deal wit this..

[action]

My database deals with sports team game fixturing. The table calendar has schedules for games where each record shows away teams playing home teams in a time slot. I have written a query to show what team members play in these teams based on that timeslot which is in the calender. My query runs well if it is based on just the home team id or just the away team id but won't run if I link both as the relationship is between home/away and teamid in another table.

I have tried running two separate queries and merging them into one but with mixed results.

Is it possiable to write some code to create a temp table which can have both queries append the results into this then once a report is run then delete the table? If so how do I do this?

Or is there a better way?

Thanks

 

[GumbyD]

Query

There are a few ways to do what you want. One would be to bring in the secondary table two times and set the joins from the main table to outer joins.

Option 2 - Change the first query to a make table query and run it. Then change the second query to an append query and add the records to the table you just built.

Option 3 - Create a third query that is a Union query and puts the first two queries together for you.

Hope that is what you were looking for!