I have a report that is running a query that limits the data based on the information from the control form. On the bottom of this report, I have been asked to pull in totals for (4) fields based on a different table and criteria. The values needed run correctly from the query.
The main report is rptCCE Employee Development Report - Directors
The main Query for this report is qryCCE Employee Development Report - Director.
The report called rptDegreeBydirector uses a query called qryDegreeByDirector.
I have tried unsuccessfully to encorporate rptDegreeByDirector as a subreport to rptCCE Employee development Report - Directors.
What am I doing wrong? A copy of the master database is attached to this thread.