Results 1 to 2 of 2

Thread: top values (97)

  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    top values (97)

    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

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •