?
Solved

Crosstab query Questions

Posted on 2004-11-08
3
Medium Priority
?
188 Views
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???
thanks
0
Comment
Question by:neonlights
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
bramsquad earned 1500 total points
ID: 12526819
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.

~b
0
 

Author Comment

by:neonlights
ID: 12527017
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
0
 

Author Comment

by:neonlights
ID: 12544351
Thanks bramsquad, I filtered for year and it is all fine now...

Thanks

cheers!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month16 days, 20 hours left to enroll

862 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