Top 3 values in Charts

[Robbie Doo]

There are a lot of inquiries about Top 3 or Top 10 Values in Reports. Is
there a way to do the same for charts?

 

[Tom Wickerath]

Hi Robbie,

Have you tried using a query as the recordsource for your chart, along with
the TOP predicate in the SQL statement of the query?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Robbie Doo]

Hi Tom:

For some reason I never get the right results with queries. I usually leave
the queries open and get the results in the reports.
I tried to do a top 3 in the query I was getting error messages so I gave up.

 

[Robbie Doo]

BTW, I get the following msg:

"You have written a subquery that can return more than one field without
using the EXISTS reserved word in the main query's FROM clause. Revise the
SELECT statement of the subquery to request only one field."

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "TopQuery.mdb" which might help.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Tom Wickerath]

Hi Robbie,

Your subquery should return only one field. Try Access MVP Allen Browne's
tutorial on using subqueries:

Subquery basics
http://allenbrowne.com/subquery-01.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Robbie Doo]

Thank you guys, I will check them out.

Hi Robbie,

Your subquery should return only one field. Try Access MVP Allen Browne's
tutorial on using subqueries:

Subquery basics
http://allenbrowne.com/subquery-01.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Robbie Doo]

Hi Roger:

I used your SQL in my database but I don't get the results I'm looking for.
Here's my situation: I have a "Error Classes" table, which has about 20
error codes. This table is linked to the Main_FS table and is used as a
drop-down on the form.

What I need to do is pick the top 3 errors for each month and show them on a
bar-chart with the percentage.

Any help?