Combining Two Queries for One Report

ebarrera

Registered User.
Local time
Today, 12:30
Joined
May 7, 2008
Messages
34
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom