Trying to display query paramiters on the query based report

[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??

 

[Allen Browne]

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

 

[Duane Hookom]

IMHO, parameter prompts aren't good practice
http://www.tek-tips.com/faqs.cfm?fid=6763.

However you can simply add a text box to your report with a control source
that matches you prompt:
=[Enter Start Date]

 

[fcmedina78]

Thanks for your help guys!

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.

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??