Creating Subreports

T

Troy Scott

I am trying to insert a subreport in a report. The report is based off on a
query that prompts the user for a beginning and ending date. The subreport
is on a query that has a date field, but it does not contain any criteria.

The problem I have is the subreport shows up on each page with the same
info. I want the subreport to show up at the end of the main report, which
is usually on the same page near the bottom. HELP!

Many thanks,

Troy
 
D

Duane Hookom

Sounds like the subreport should be contained in the REPORT FOOTER section
of the main report.
 
T

Troy Scott

That worked Duane, however when I enter the beginning and ending criteria to
run the report I only get the correct date on the main form. The subreport
shows all dates instead of the same criteria. How do I get the subreport to
query on the same date? I tried entering the criteria on the subreport
query, but when I run it I'm in a loop it seems of it asking me beginning
and ending date.

Troy
 
D

Duane Hookom

Don't use parameter prompts in queries. Create a form with text boxes or
other controls for the beginning and ending dates. Assume a form "frmDates"
with text boxes "txtStartDate" and "txtEndDate".
You can then set the criteria in the report's record source query to:
Between Forms!frmDates!txtStartDate and Forms!frmDates!txtEndDate
 
T

Troy

ok, I think I understand that, but how will I link the
form to the report? In other words, how will I "start" it
if it's in a form?

Troy
 
Top