Printing date parameters on a report

[Ken V]

I have created a couple paramter queries which I use in various reports. I
would like to have the date parameters (start and end) print on the top of
the report. Can anyone help with this?

Thanks in advance.

Ken

 

[George Hepworth]

The way to include the date parameters on the report is to add controls for
them to the top of the report.

If you are not already doing so, the most practical way to approach this is
to have controls on your form into which the parameters are entered (start
date and end date). Then, the query's parameters look at those controls on
the form for their values, and the controls on the report can also look at
those controls on the form to get their values.

 

[fredg]

I have created a couple paramter queries which I use in various reports. I
would like to have the date parameters (start and end) print on the top of
the report. Can anyone help with this?

Thanks in advance.

Ken

Let's assume your query parameter prompts are:
[Enter Start Date] and also [Enter End Date].

Add an unbound control to the report header.
Set it's control source to:

= "For sales between " & [Enter Start Date] & " and " & [Enter End
Date]

Note that the text within the brackets above must be identical to the
bracketed text in the query.

 

[Ken V]

Fred, worked like a charm. Thank you