I want to use the Top Values feature to find the top five items (based on a date field in Descending order). However, I have a second filed listing consultants names and I want to find the top five FOR EACH consultant... Any suggestions? Andy
Results 1 to 2 of 2
Thread: top values (97)
-
5 Star Lounger
- Join Date
- Mar 2001
- Posts
- 989
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2003-01-28 12:58top values (97)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
4 Star Lounger
- Join Date
- Jan 2001
- Location
- Altnau, Thurgau, Switzerland
- Posts
- 447
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2003-01-28 13:35Re: top values (97)
Run the query once for each consultant, filtered on that consultant (eg a Form:SubForm).
or (for continuous form)
Have a sub query (to filter on consultant, returning top 5 records) embedded in the main query which lists your consultants.
