>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only