Parameter Values in Report Title

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

I have created a report based on a parameter query. The query prompts the
user to enter a Start Date & an End Date. The criteria for my date field in
the query is:

Between [Start Date] and [End Date]

I would now like to use the Start & End date values in my report title.

Example: Classes Scheduled from [Start Date] to [End Date]

Can I do this? If so, how?

Thanks!
 
One way is to go to the query and in design view scroll to the right to a
blank column and add a field like this --
Start: [Start Date]
and another like --
End: [End Date]

Use these fields in your report.

I always copy the parameter prompts and paste just to make sure they are
exactly the same.
 
If your query uses a form (like Report Date Range) to prompt for the date,
you can add a text box in design mode in the report header with a Control
Source of something like:

="For Data Between: " & Format([Forms]![Report Date Range]![Beginnining
Date],"m/d/yy") & " and " & Format([Forms]![Report Date Range]![Ending
Date],"m/d/yy")
 
Exactly as you have it now, making sure the prompt names are the same on the
report as you have used in the query.
Create a textbox on the report with the control source
="Classes Scheduled from " & [Start Date] & " to " & [End Date]
 
Thanks Karl! This worked perfectly:)

KARL DEWEY said:
One way is to go to the query and in design view scroll to the right to a
blank column and add a field like this --
Start: [Start Date]
and another like --
End: [End Date]

Use these fields in your report.

I always copy the parameter prompts and paste just to make sure they are
exactly the same.
--
KARL DEWEY
Build a little - Test a little


Lynn said:
I have created a report based on a parameter query. The query prompts the
user to enter a Start Date & an End Date. The criteria for my date field in
the query is:

Between [Start Date] and [End Date]

I would now like to use the Start & End date values in my report title.

Example: Classes Scheduled from [Start Date] to [End Date]

Can I do this? If so, how?

Thanks!
Click to expand...
Click to expand...
 
Back
Top