Showing Date Range on Report

[srburk]

The report pulls from a query. Within the query is a date field with criteria:
Between [Start Date] and [End Date]

This pulls the correct information with no problem.

Is there a way to have the date range that was entered be displayed on the report header section without prompting the user to enter the dates again?

For example: The user selects 07/01/2004 through 07/10/2004 for the report. Is there a way for the report to automatically display:
"Data range is between 07/01/2004 and 07/10/2004"

Scott

 

[Hayley Baxter]

=[start date] & [end date] will display the selected dates on your report.

 

[srburk]

=[start date] & [end date] will display the selected dates on your report.

Yes, but if I do that in my report, it does the following when opening the report:

It prompts the user to enter the date range. (to pull the correct data)
It prompts the user to enter the date range again. (for the report title)

Is it possible to enter it only once and have it pull the right information AND put the date range on the report without having to enter it twice?

 

[Hayley Baxter]

It shouldn't ask you for it twice, say for example you have between [start date] and [end date] under criteria in your query. You report is based on your query. If you then put a text box on your report and set this to = [startdate] and [end date] it should display in the header what your search dates were to and from.

 

[srburk]

It shouldn't ask you for it twice, say for example you have between [start date] and [end date] under criteria in your query. You report is based on your query. If you then put a text box on your report and set this to = [startdate] and [end date] it should display in the header what your search dates were to and from.

In my query, the criteria states:
Between [Enter start date] And [Enter end date]


In my report, under the report header, I created a "text box", left the lable as is and typed the following into the Data Control Source:
=[Enter start date] And [Enter end date]

Now, I end up with a -1 in that field; however, it only ask me the date once now. It ask me the date once but how to fix the -1?

 

[srburk]

It shouldn't ask you for it twice, say for example you have between [start date] and [end date] under criteria in your query. You report is based on your query. If you then put a text box on your report and set this to = [startdate] and [end date] it should display in the header what your search dates were to and from.

I figured out a workaround based on your answer. I wasn't able to use = [startdate] and [end date], I had to make two separate text boxes for each...

=[startdate]
=[end date]