A
Atif
Scenario is, I am creating Pivot Chart view of three Queries to display
Business generating by Sales Person on Month, Quarter and Yearly basis.
Three Command Buttons are associated with three different queries Month,
Quarter, and Year (same query saved with three different names). In Pivot
Chart view Category Filed contains respective criteria Month, Quarter or Year.
Is there any way that I use only one query and change its criteria on fly
(Month, Quarter or Year), or can I generate query using code and define
fields (Filter, category, data filed) myself.
Business generating by Sales Person on Month, Quarter and Yearly basis.
Three Command Buttons are associated with three different queries Month,
Quarter, and Year (same query saved with three different names). In Pivot
Chart view Category Filed contains respective criteria Month, Quarter or Year.
Is there any way that I use only one query and change its criteria on fly
(Month, Quarter or Year), or can I generate query using code and define
fields (Filter, category, data filed) myself.