charts from a crosstab query

H

happywitchie

FormA contains a combo box - when you select an item from there, it refers
to a crosstab query and opens up FormB which contains data relating to the
item selected on FormA.

I want to put a chart on FormB so that the data is also represented
graphically when this form opens. Is it possible to do this using the
Crosstab query as my data feed for the chart? The "Month" field is the
field that's been "crosstabbed" and it's the sum of each month that I want
plotted on the chart. I've tried a few things but it's not doing it
properly and I wondered if anyone could give me a pointer on how to do this.

Please let me know if you need any more detail.

Thanks
hw
 
Top