Putting date range on report

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have a report that shows a chart that runs off a
parameter query using the date(Between [Start Date:
(mm/dd/yy)] And [Stop Date: (mm/dd/yy)]). The chart
comes up fine, but I wanted the date range to be
displayed on the page itself. I created an unbound
textbox and used (=[Enter Start Date: (mm/dd/yy)] & " -"
& [Enter Stop Date: (mm/dd/yy)] as the control source.
Theoretically, the date range should be displayed.
Right???? What comes up is #Name?. Any help here would
be appreciated.

Frank
 
I have a report that shows a chart that runs off a
parameter query using the date(Between [Start Date:
(mm/dd/yy)] And [Stop Date: (mm/dd/yy)]). The chart
comes up fine, but I wanted the date range to be
displayed on the page itself. I created an unbound
textbox and used (=[Enter Start Date: (mm/dd/yy)] & " -"
& [Enter Stop Date: (mm/dd/yy)] as the control source.
Theoretically, the date range should be displayed.
Right???? What comes up is #Name?. Any help here would
be appreciated.

Frank
Click to expand...

Why the "(" at the beginning of the control source?
Also, your text within the brackets in the report control's control
source is not the same as the bracketed parameter text in the query.
It must be identical.

=[Start Date: (mm/dd/yy)] & " - " & [Stop Date: (mm/dd/yy)]
 
That was an error in my post. The parameter query has
[Start Date:(mm/dd/yy)] And [Stop Date: (mm/dd/yy)] and
so does the report. I didn't use the paranthesis in the
sequences. I think I figured it out though. The Record
source wasn't listed as my parameter query. I changed
it, but now I have 22 pages of report which equates to
the 22 employees that I have. Maybe you can direct me on
how to fix this problem. Another final problem is that
my boss wants the values to go from greatest to least
depending on the date parameters. I cannot find anywhere
where you can change something like that.

Frank
-----Original Message-----
I have a report that shows a chart that runs off a
parameter query using the date(Between [Start Date:
(mm/dd/yy)] And [Stop Date: (mm/dd/yy)]). The chart
comes up fine, but I wanted the date range to be
displayed on the page itself. I created an unbound
textbox and used (=[Enter Start Date: (mm/dd/yy)] & " -"
& [Enter Stop Date: (mm/dd/yy)] as the control source.
Theoretically, the date range should be displayed.
Right???? What comes up is #Name?. Any help here would
be appreciated.

Frank
Click to expand...

Why the "(" at the beginning of the control source?
Also, your text within the brackets in the report control's control
source is not the same as the bracketed parameter text in the query.
It must be identical.

=[Start Date: (mm/dd/yy)] & " - " & [Stop Date: (mm/dd/yy)]
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top