Top 10 report

[John.Woody]

Does anyone know of an easy way to set up a report showing the top 10 results only? I Can do this using the counter method and cancel event etc but the totals on the report footer sum all of the figures in the query and so are incorrect.

I know microsoft document a Dynamic Counter but due to the variables I need it is proving very difficult to set up and work correctly in SQL. I was wondering if anyone knows of an easier method?

 

[Rich]

Can't you just use a Select Top10 query?

 

[John.Woody]

Probably, Can't see the woods for the trees at the moment.

I have Fields for CompanyID & Revenue amoungst others, Sort Revenue Desc but limit the list to the top 5 or 10 determined by a control on a form.

Could you elaborate a bit for me please?

 

[Agism]

I believe what Rich is saying is to base your report on a query that only pulls the top 10 records.

In the design view of the query, you will see a field in the tool bar that says "All", "100", or something of the sort. If you make that field say "10", then only the top 10 records will pull.

 

[WayneRyan]

From the help files:

SELECT TOP 25
FirstName, LastName
FROM Students
WHERE GraduationYear = 1994
ORDER BY GradePointAverage DESC;

However, if the are 40 people with a 4.0 you will get them
all, not just 25. Software has a hard time making decisions
sometimes.

Wayne

 

[John.Woody]

Thanks all I think I'm on the right track now. It's amazing the little bits that bypass you.

John