Charts from Queries - 6 Fields!!!!!???? Is That it!!!!???

[manix]

I am infuriated with MS Access now!!!!!

I am building a nice little system and now I am developing the reporting features. I want the results of a query to populate a chart.

Basically it is a monthly chart, so would have 12 months along the x axis and a quantity on the Y. A simple line chart!

I want 4 different lines each representing a form of occurrence. However Access limits you to using a maximum of 6 fields! Are you serious!!! I need 12 just for the months!!!!

Is this a serious feature of Access or am I being stupid?

I know many people who export a lot of stuff to Excel for charting, and now I know why. Is this my only option? I wanted to avoid multiple applications, but if I have to, will have to learn how to automate to an excel template, some thing I am not aware of how to do currently and am limited in my VB programming abilities.

I cannot believe that a powerful tool such as Access could be sooooo limiting in it's reporting capabilities!

 

[petehilljnr]

I think you've got the query for your chart wrong (for this purpose).

You should have something like:

Month: Quantity:
1 14
2 23
3 44
4 40
5 34
.... etc

When the chart wizard comes up, drag Month down to the x-axis box and put Quantity in the value part.

If you've got multiple lines for your chart, you have to add a Series column to your query, and then drag that into the Series box in the chart wizard.