R
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?
there a way to do the same for charts?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
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
__________________________________________
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
__________________________________________
R
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.
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.
R
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."
"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."
R
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
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
T
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
__________________________________________
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
__________________________________________
R
Robbie Doo
Thank you guys, I will check them out.
Tom Wickerath said: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
__________________________________________
R
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?
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?