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???