Diplaying Parameter queries in a Report

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have created a Parameter query which prompts the user to
enter a Start Date and then an End Date.

I then want to be able to use the Start and End date in my
Report header. I have created two text fields on my
report - Start & End date - but it keeps on picking out
dates from the main body of my report when all I want it
to do is pick up the Start & End date as entered in the
Parameter query. Any guidance would be appreciated.

Steve
 
What are the names of the parameters?

Example parameter: [Enter Start Date]

On the report you need to set a control as follows:

Control Name: txtShowStart
Control Source: [Enter Start Date]

Note that the control source must be entered exactly the same as the parameter
in the query. No extra spaces or missing spaces.
 
Back
Top