I
iccsi
I want to have a chart for different group, so I put the cahrt on the
group footer to show the chart for the group.
Because the chart only shows one group, the row source need change
every time. I tried to use DAO.QueryDef to modify the query every time
on FooterFormat even.
It seems the the chart can only have one SQL statment on FooterFormat
Event.
If I am not on the right track, please advise me any other solutions.
Any information is great appreciated,
group footer to show the chart for the group.
Because the chart only shows one group, the row source need change
every time. I tried to use DAO.QueryDef to modify the query every time
on FooterFormat even.
It seems the the chart can only have one SQL statment on FooterFormat
Event.
If I am not on the right track, please advise me any other solutions.
Any information is great appreciated,