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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top