Creating Chart From Query With Date Range Error

[Guest]

I have a query with the following prompt in the strDate column.

Between [Enter Beginning Date] And [Enter Ending Date]

When I try to create a chart from this query using the chart wizard, I get
an error when I try to preview the chart. It tells me that it cannot
recognize the [Enter Ending Date]. Does anyone have any suggestions on how I
can fix this?

 

[Duane Hookom]

Consider kicking your application up a notch and using controls on forms for
criteria rather than unforgiving, spartan parameter prompts.

BTW: I expect your chart's Row Source property is a crosstab query. If so,
you are required to enter the data types of all parameters. Select
Query->Parameters and enter
[Enter Beginning Date] DateTime
[Enter Ending Date] DateTime