Important Question Regarding Use of Combo Box to affect a Graph

[rovolution]

I know some of you might think "hey why not just use Pivot Charts?" but I really want to do it this way b/c the Pivot Chart pie graph does not display percentages.

I first tried the example described in the link below:

http://support.microsoft.com/?kbid=208335

I am using Access 2003. I used the Northwind database as they described, but when I double clicked on my form, I kept getting a strange error that read: Cannot use crosstab of a non-fixed column as a subquery." I am quite the novice when it comes to Access so very descriptive steps would be helpful. Thanks.

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=275070

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[rovolution]

i looked at that earlier and it really didnt help much

 

[rovolution]

PLEASE someone help me!!! I plead of you!!!! I must get rid of this error!!!!!