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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top