Access 2000 Chart/Graph

[TGG61]

I have an Access 2000 query that asks the user for the start date & end date for a report or chart. In the Access report, I can display the start & end dates entered in the query in the header of the report.

Problem: When I create a chart/graph using the same query, I am unable to display the start & end dates in the chart per the date prompts in the query.

Any ideas on how I can display the date range in the chart/graph?

Thanks much.

[ADezii]

Store the actual Prompt in a Calculated Field, then set the Control Source of a Text Box equal to this Field. Suppose you have a Parameter Prompt on a [LastName] Field in an Employees Table as such:

[Enter Last Name:]

Store the actual Return Value in a Calculated Field, [Last], in the Query, and reference this Field:

Last: [Enter Last Name:]

[TGG61]

Store the actual Prompt in a Calculated Field, then set the Control Source of a Text Box equal to this Field. Suppose you have a Parameter Prompt on a [LastName] Field in an Employees Table as such:

[Enter Last Name:]

Store the actual Return Value in a Calculated Field, [Last], in the Query, and reference this Field:

Last: [Enter Last Name:]

Thanks for the tip. I tried your ideas in my Access 2000 chart but always get an error message : #name?. I do have the text boxes pointing to the correct query field (Date). TGG