John.Woody
Registered User.
- Local time
- Today, 11:06
- Joined
- Sep 10, 2001
- Messages
- 354
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?
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?