Print Date Criteria in Chart

[tbmac61]

Hi all,
I created a query and chart for a date range in my database.
My query asks for input from the user to provide a date range.
I need to print that date range, the query is based on, under the heading for the chart.
Is there an easy way to make this happen?
Thanks!

[June7]

You are using query parameter input prompts? I never use them.

Options:

1. Construct fields with expressions like:
StartDate: [Enter start date]
EndDate: [Enter end date]
Then criteria under the native date field would be:
BETWEEN [Enter start date] And [Enter end date]
User will be prompted once for start date and once for end date. The start and end dates will show on each row. These constructed fields can be ControlSource in textboxes in report header.

2. Instead of parameter prompt for input, have user input criteria in textboxes on form. The query would refer to the form textboxes as input parameters and report textboxes ControlSource can reference the form textboxes for the input date.

3. Use the OpenArgs argument of DoCmd.OpenReport to pass values input on form to report and textbox ControlSource expressions can extract values from the OpenArgs string.