How to display the Parameters in a query in a form/report/page

J

Jay

Hi

I use "Between" and "And" in a parameter query with respect to dates.

I wish to display the two dates in the query result ideally in a
form/report/page.

How can I do it ?

Thanks

Jay
 
V

Van T. Dinh

Not sure about Form but in the Report, you certainly can.

Let's say your Parameters are [StartDate] and [EndDate], you can set up 2
TextBoxes on the Report and simply set the ControlSource to:

= [StartDate]

and

= [EndDate]

including the equal sign. When the Report is opened, Access will
automatically pick up these 2 param values and insert the values into the
TextBoxes.
 
Top