>Is it possible to have a chart run (with a query as its datasource) and show only the "Top 10" of the query results? I am using MS Graph as the charting source in MS Access 2000.
With Access 2000, you can use the TOP clause like this:
select top 10 *
from TableSomething
Order By SomeField DESC
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com