Only display top 6 results on report chart

[wlkr.jk]

Hi all,

I'd like to only display top 6 results on a report chart. Any idea how to do this?



Depending on what is entered into the database, there could be a possible 200 items listed on the x axis of the chart, which would just be ridiculous. So, right now I have the chart displaying a count of the number of times each item is entered. Just want to top 6 counts.

Thanks!

[ranman256]

Make the query show TOP 6.

[wlkr.jk]

Thanks for letting me know about TOP.

However, this will display the TOP 6 "counts", so if there is 2 items with the same count, it will display both of them. Therefore, I've got 7 items displayed on my chart (6 unique counts).

How do I limit it to 6 items? I've tried using LIMIT TO but you're apparently not allowed to use that in Access.

[ranman256]

Wow...if I say 'top 6', I didnt know it would disobey and show 7. You got me on that one!

[ranman256]

The only other option is make a macro to:

append the top6 qry to a rpt table (with autonumber)
Then delete everything w counter >6
Then run the report off that table.

[June7]

What you want might be possible in query, not sure.

Bing: Access query TOP N tie

http://www.tech-archive.net/Archive/.../msg01502.html

http://support.microsoft.com/kb/120608

http://allenbrowne.com/subquery-01.html#TopN