Access Chart Report - Date Range

[sausmus]

I am using access 2000 trying to chart several graphs on one report. All three charts has different row source but asks for a same date range. what is the best way using vba to change the parameter on a saved query?

Thanks
Shan

 

[sausmus]

I did in Marco and its works.

setwarnings - on
echo - Yes
OPenQuery - in query1 put parameter Between Forms![frmExample].[startdate] and Forms![frmExample].[enddate]
OPenQuery - in query2 put parameter Between Forms![frmExample].[startdate] and Forms![frmExample].[enddate]
OPenQuery - in query3 put parameter Between Forms![frmExample].[startdate] and Forms![frmExample].[enddate]
close query1, query2, query3
OpenReport

Form - run Marco (Report View with 3 different chart)

I know this is not best way but it works

 

[muckshifter]

Hey! well done ... I would not know where to start, so pat yourself on the back anyway.