Date range in header

[Cheese]

I have created a report based on a query that runs criteria for a date range
sometime ago.
I am editing the report to show the date range in the header and when I add
a text box in the header with the following for the control source: =" For
the period of " & [Enter start date using format mm/dd/yyyy] & " And " &
[Enter end date using format mm/dd/yyyy], I get repeat dialog boxes asking
for dates... How can I rectify without re-creating the report?

 

[fredg]

I have created a report based on a query that runs criteria for a date range
sometime ago.
I am editing the report to show the date range in the header and when I add
a text box in the header with the following for the control source: =" For
the period of " & [Enter start date using format mm/dd/yyyy] & " And " &
[Enter end date using format mm/dd/yyyy], I get repeat dialog boxes asking
for dates... How can I rectify without re-creating the report?

My guess would be that there is a difference with the text inside the
brackets between what is written in the report and what is written as
the query criteria. Perhaps one has a space missing or an extra
punctuation mark, i.e. [enter Start Date:] is not the same as [enter
Start Date].

 

[Duane Hookom]

You must use the exact same parameter prompt as you use in the report's
record source. However, IMHO, parameter prompts are not good programming
interface. You should use controls on forms for criteria entry.
Check this link http://www.tek-tips.com/faqs.cfm?fid=6763

 

[KARL DEWEY]

Add the date range criteria as an output field in the query select statement
like this --
SELECT UrTable.*, [Enter start date using format mm/dd/yyyy] AS StartDate,
[Enter end date using format mm/dd/yyyy] AS EndDate
FROM UrTable
WHERE UrDateField Between [Enter start date using format mm/dd/yyyy] And
[Enter end date using format mm/dd/yyyy];

Use StartDate and EndDate in the report header --
=" For the period of " & [StartDate] & " And " & [EndDate]

 

[John Spencer]

Usually when I see this, I have a variation in the spelling in the query and
in the report. An extra space or parens will make the two different.

[Enter start date using format mm/dd/yyyy] is not equal to
[Enter start date using format mm/dd/yy] is not equal to
[Enter start date using format mm/dd/yy]

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County