Why doesn't the chart display the data from the query as expected?
I have attached the Access database. I cannot figure out what I thought was a simple chart does not display the way I expected it to be.
If you look at Form1, I had a simple chart based upon a Query. (MonthChartList) If I look at the property of the chart on Form1 and look at the Row Source, it appears to me that the query is running correctly. Why doesn't the chart show me the correct Month/Year found in the query column
labeled Expr21? I assumed that the results of the query would display on the chart as
Oct 2018, Nov 2018, Dec 2018, etc. What is the chart doing? Ultimately I need to display Open Sales Dollars for any given Month/Year that the query has for results.
Thanks in advance for any help!
RG
OpenSales-.accdb
If you look at Form1, I had a simple chart based upon a Query. (MonthChartList) If I look at the property of the chart on Form1 and look at the Row Source, it appears to me that the query is running correctly. Why doesn't the chart show me the correct Month/Year found in the query column
labeled Expr21? I assumed that the results of the query would display on the chart as
Oct 2018, Nov 2018, Dec 2018, etc. What is the chart doing? Ultimately I need to display Open Sales Dollars for any given Month/Year that the query has for results.
Thanks in advance for any help!
RG
OpenSales-.accdb
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
It looks similar to me. You have another format on the Y-axis and a thicker font, but I didn't touch those - only the query was modified to sort on the YYYY-MM value.
ASKER
Thanks for your help and explanation Gustav!!
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
I saw your example. Absolutely great! Thank you for your quick response. Rather than just using your solution, I tried to re-create
yours. I created a query called MonthChartList_2 and used your suggested code.
I created the chart on Form1. What am I doing wrong? It does not come out in the format you have. What am I not seeing?
I intend awarding you for your solution to my problem but as I said, I just do not want to copy and paste your solution without understanding what the heck I am doing wrong. I have attached my file again. Would appreciate you taking a look.
Thanks again!
RG
OpenSales-.accdb