Joel_123 via AccessMonster.com wrote:
Thanks for the response. Could I UNION the two payroll queries together to
use as the main form query or does that still count as including subreport
information? I have tried using various tables and creating queries but I
cant seem to get it to work.

On my report, I have grouping turned on and I am grouping on operator on the
main form. The subreports are in the Detail section and are one after the
other with every field listed in my previous post (not all of them are
visible).


Instead of using oarameter prompts in the query, you xould
use a form with text boxes where users can enter the start
and end dates. Then the query parameters would look like:
Forms!theform.starttextbox
Forms!theform.endtextbox
This way the queries know how to get each parameter's value
without asking for it.

I guess I don't understand what the subreport is doing.
Maybe it should be in the operator group footer instead of
the detail section.

--
Marsh
MVP [MS Access]