Charts

[sifuhall]

Hello everyone!

I'm trying to implement basic charting on a query that returns data like this

Category	Question	Scores
Infrastructure	Vmware	1
Infrastructure	NetApp	1
Infrastructure	Tivoli	4
Infrastructure	Citrix	1
Infrastructure	Windows Clustering	8
Components	Reporting Services	8
Components	T-SQL	9
Components	Analysis Services	4
Components	Integration Services	3
Components	Database Mail	9
Components	SQL Agent	9
Components	Linked Servers	9
HA	Replication	9
HA	Database Mirroring	8
HA	Log Shipping	8
HA	AlwaysOn	9
Maintenance	Backup & Restore	9
Maintenance	Recovery Models	9
Maintenance	DB Creation & Configuration	9
Maintenance	DB Roles & Security	9
Troubleshooting & Performance Monitoring	Index Fragmentation	9
Troubleshooting & Performance Monitoring	Blocking	9
Troubleshooting & Performance Monitoring	Deadlocks	9
Troubleshooting & Performance Monitoring	Database Flags	8
Troubleshooting & Performance Monitoring	Activity Monitory	9
Troubleshooting & Performance Monitoring	Execution Plans	9
Troubleshooting & Performance Monitoring	Profiler and Traces	8
Troubleshooting & Performance Monitoring	SQL Counters	9
Troubleshooting & Performance Monitoring	DMVs	9

However when I click on the chart tool to add it to my form and select the query as the record source I get:

Either the table or query you selected doesn't have enough valid fields to provide data for a chart or the fields can't be retrieved. Select a table or query with at least one numeric, date, or text field.


It would seem I have that? Any ideas?

 

[theDBguy]

Hi. Welcome to the forum. The formatting is off a bit, so it's a little hard to read the data. Can you post a screenshot or a sample db instead? Thanks.

 

[plog]

Is [Scores] actually a numeric field? You can't just go by what your eyes see--you need to dig into the data type that the computer is given for that field.

 

[sifuhall]

Hopefully, this will be better.

Category and question are text and scores in numeric

EDIT- Looks like my images isn't showing up

 

[JHB]

Could you post the data either in a MS-Access database or in an Excel sheet, zip it because you haven't post 10 post yet.

 

[sifuhall]

Thanks, I have attached the data.

 

[theDBguy]

Thanks, I have attached the data.

Hi. Thanks. Which version of Access are you using. I am only on 2010 right now and when I linked to your Excel file, I was able to create a chart on a form with your data.

 

[sifuhall]

Hi. Thanks. Which version of Access are you using. I am only on 2010 right now and when I linked to your Excel file, I was able to create a chart on a form with your data.

Thank you. I'm using 2016.

However, I was able to create an empty table with the same specs and use the table to create the chart, then change the recordsource back to the query and it works just fine.

Thanks for the help!

 

[theDBguy]

Thank you. I'm using 2016.

However, I was able to create an empty table with the same specs and use the table to create the chart, then change the recordsource back to the query and it works just fine.

Thanks for the help!

Okay. Glad to hear you got it to work. Good luck with your project.