Parameter Values in Report Title

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!
 
K

KARL DEWEY

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.
 
M

Matt Wickham

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")
 
D

Dennis

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]
 
L

Lynn

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top