Link to home
Start Free TrialLog in
Avatar of neonlights
neonlights

asked on

Crosstab query Questions

Hi I am trying to do cross tab query for monthly production:

and my problem is that when I do monthly, I only want to do 2004, not 2003, it is calculating altogether.... how do I solve this?

This is my access query:

Format([DateProduction],"mmm")  --- should I have to add 2004???
thanks
ASKER CERTIFIED SOLUTION
Avatar of bramsquad
bramsquad
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of neonlights
neonlights

ASKER

hi, thanks for your message. But, I fixed it... but, I have one other problem:

When I try to do mschart, I have 60 rows, and 2 columns.

id    qty
{60 ids} and their qty

So, my problem is when do this graph, I do not see all the axis (x) on the bottom, it shows every 3 .... how do I fix this? and is there any way that I can modify the mschart title bar...and so forth...will be helpful if you can give me some suggestions on mschart... today is my first day on mschart

Thanks
Avatar of neonlights
neonlights

ASKER

Thanks bramsquad, I filtered for year and it is all fine now...

Thanks

cheers!