Trying to display query paramiters on the query based report

  • Thread starter Thread starter fcmedina78
  • Start date Start date
F

fcmedina78

I have a report based on a query that does the following:
displays store number, dollar amount, and date
the date has a condition where the user enters the starting date and ending
date
The created a report that has sums the dollar amounts by store but I need the
report to display the starting and ending date entered by the user.

Any Help??
 
You should be able to use the same name in the report as you used for the
parameter in the query.

If the query paramter contains:
Between [starting date] And [ending date]
then in the ControlSource of a text box on the report, use:
=[starting date]

An alternative approach is to use a form where the user can specify the
dates, and then refer to the form in your report. Details:
http://allenbrowne.com/casu-08.html
 
Thanks for your help guys!

Allen Browne said:
You should be able to use the same name in the report as you used for the
parameter in the query.

If the query paramter contains:
Between [starting date] And [ending date]
then in the ControlSource of a text box on the report, use:
=[starting date]

An alternative approach is to use a form where the user can specify the
dates, and then refer to the form in your report. Details:
http://allenbrowne.com/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

fcmedina78 said:
I have a report based on a query that does the following:
displays store number, dollar amount, and date
the date has a condition where the user enters the starting date and
ending
date
The created a report that has sums the dollar amounts by store but I need
the
report to display the starting and ending date entered by the user.

Any Help??
Click to expand...
Click to expand...
 
Back
Top