3 query's into 1

[oo0tommyk0oo]

Hi, I am trying to set up a Database to track employees and seats. Thanks to Rod I have a great database design which has allowed me to understand how the relationships work.

I have created three query's to show the information i need
1. Seat/Employee = Who sits where
2. Seat/Manager = Seats under control of which manager
3. Agile = Which seats are agile and what group if they are/ what employee is agile and what group if they are.

The problem is i have found it impossible to create a query to show all this information together....

So Seat number = Who sits there (if anyone)/ if an agile group say which group = which manger is it under



Is this possible or am i barking up the wrong tree?

Thank you for any help.

Tom

[June7]

Didn't look at the project but quite possibly these queries can't be combined in any way. Could probably build a report/subreport(s) arrangement to display the related data.

[oo0tommyk0oo]

Will give reports a try