Access Chart Report - Date Range

S

sausmus

Joined
May 24, 2006
Messages
5
Reaction score
0
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
 
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 :)
 
Hey! well done ... I would not know where to start, so pat yourself on the back anyway. :thumb:

:)
 
Back
Top