Crosstab query Questions

Posted on 2004-11-08
Last Modified: 2013-12-25
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???
Question by:neonlights
    LVL 8

    Accepted Solution

    yes you will have to also filter for the year.  (right now youre filtering for the three digit month value)  i.e. "Jan", "Feb", "Mar"...etc

    post your SQL and ill fix it for you.


    Author Comment

    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


    Author Comment

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



    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Article by: Martin
    Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now