>>I have a chart embedded into MS Access 2000 using MS Graph. Currently, the chart has a query as a record source. The query has a timeframe hardcoded into it. Now, the user has requested the ability to select specific dates for the query. If I put the code in the query criteria field (Between [Enter beginning Date] And [Enter ending Date]), then try running the chart, it gives me an error that "Beginning Date" is invalid. Is there a way that I can have the chart run the query, ask the user to input a timeframe, and then show the chart?
>>
>>Also - This is the first time I have worked with charts in Access, so if anyone can point me to some good documentation I would appreciate it.
>>
>>TIA!!!!
>
>Are [Beginning Date] and [Ending Date] defined as parameters in the query? And is the criteria defined as "Between [Beginning Date] And [Ending Date]"?

-------------------------------

I don't really understand what you mean about [Beginning Date] and [Ending Date] being defined as parameters in the query. But, yes, the criteria is defined as you mentioned. If I run just the query it works just fine, it is the chart that is having the problem.