>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]"?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement