Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying Prompted Date on Report 1

Status
Not open for further replies.

laina222

Technical User
Sep 7, 2001
172
US
Hi all,

I have a report based on several queries that all prompt for a Date range - [Enter Start Date] and [Enter End Date]. What I need to do is get these dates to show up in my final report. Any ideas?

Thanks!!!
 
You can add a text box to your report with a control source like:
=[Enter Start Date] & " to " & [Enter End Date]

You should really kick your programming up a notch and never use parameter prompts. Try using controls on forms for all criteria value entry.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top