Putting in the Date ranges on a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all..

I have a report that is based off of a parameter date query. When the
person clicks on the report they are asked to put in a start date and an end
date. Then the report is generated.

What I want them to see is the dates they entered. I have tried this code
from another post:

="For sales between " & Format([Start Date],"mmmm dd, yyyy") & " and "
& Format([End Date],"mmmm dd, yyyy")


Once it is in the rpt header or anywhere on the rpt the person has to enter
2 start dates and 2 end dates... What am I doing wrong and how do I fix
this???????

Thanks
R~
 
You need to make sure the query parameter prompt and the entry in your
unbound text field are identical. In your example, the query and report
would need to use [Start Date] and [End Date] exactly as you typed them.
Most likely your query is using something different like [Start Date:] or
[Enter Start Date] or [StartDate].
 
If these parameters are in the query, you should not have to enter them
again in the report if the query is the RecordSource for your report. Of
couse, they must be spelt exactly the same: do they have exactly one space
in their names in the query?

This article discusses a similar scenario:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
 
Rick..

That is exactly what it was... I didn't have the ":" in the report...

Mucho appreciated help!!!!!
Thanks
R~

Rick B said:
You need to make sure the query parameter prompt and the entry in your
unbound text field are identical. In your example, the query and report
would need to use [Start Date] and [End Date] exactly as you typed them.
Most likely your query is using something different like [Start Date:] or
[Enter Start Date] or [StartDate].

--
Rick B



Rhett_Y said:
Hi all..

I have a report that is based off of a parameter date query. When the
person clicks on the report they are asked to put in a start date and an
end
date. Then the report is generated.

What I want them to see is the dates they entered. I have tried this
code
from another post:

="For sales between " & Format([Start Date],"mmmm dd, yyyy") & " and "
& Format([End Date],"mmmm dd, yyyy")


Once it is in the rpt header or anywhere on the rpt the person has to
enter
2 start dates and 2 end dates... What am I doing wrong and how do I fix
this???????

Thanks
R~
Click to expand...
Click to expand...
 
Back
Top