sort by total in report?

  • Thread starter Thread starter brownbear
  • Start date Start date
B

brownbear

Hi all

I'm designing a very simple database for my college radio station to track
how many times albums are played on the station. Ive got it set up to show
the total number of plays on the report, but was wondering if there is a way
to have the report sort by the total so that it can show the most played
album at the top of the report. Any ideas how to do this or is it even
possible?

Thanks!
 
You can only sort/group by a expression from your report's record source. If
the value you want to sort by is an aggregate calculated in the report, you
need to create a totals query to join to your report's record source. This
will place the values needed into the record source.
 
Back
Top