Show date on report 1

[uapak90]

I have a report linked to a query. The query is set up where the field of date is between two certain dates. So when i open the report, it asks me for the beginning date, and the ending date. Is there any way I can show those dates on the report itself?

 

[lacasa]

I would create a form where you have two text boxes named start and end. Enter the dates in these. Create a command button on this form to open up the report. Setup your query that is used for the report so it pulls those dates from this form. On the report just add two text boxes with these values:

=Forms!Results_Report!start

and

=Forms!Results_Report!end

 

[Lilliabeth]

If you want to stick with your parameter query, place a text box in the Header of your report with this for the COntrol Source property:

=Reports![reportname]![parametername]

For example:

=Reports![rptPeriodicReport]![Enter Start Date]

--Lilliabeth