Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113

    Unanswered: Sort by Aggregate Function in Access Report?

    Hi,
    Is it possible to sort by an Aggregate Function in a Report?

    in a subfooter I have, =Count(item). I am trying to obtain a sequential sort of the Top 5 items.
    Thanks
    ======================
    Levent
    Access 3

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I don't know of a way to do what you are trying to do without doing it first in a query. You can calculate the totals and take the TOP 5 in a separate query then join the results of the query with the query that is feeding your report.

Posting Permissions

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