Combining Two Queries for One Report

[ebarrera]

I have two queries, one that has Faculty Assignements and another table that has the Faculty Assignments Detail of each course. I created a field called [FacultyCourse] which is FacultyID & Assignment. table FA does not have duplicates in [FacultyCourse], while table FAD does. I need to combine them into one report so that the report looks like the following sample.

COURSE WKS LHE FTE SPLIT TEAM FINALS RATE...
START DATE END DATE START TIME END TIME...
ACCT-101-01 18 3.0 0.20 YES YES 3.0
06/09/08 08/07/08 08:00 13:00

I try to get use the wizard and select the fields from both queries and get the error. I also tried to combine them as a query and get a blank, so the database is not connecting the two tables. Any help is greatly appreciated.

 

[boblarson]

You need to use a sub report for the details.

 

[ebarrera]

Great, this means it is possible...I will need to do some research as I have never done a sub report. At least I now know what it is called.