sort by total in report?

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!
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report to calculate total spent by customers in a customer db 8
sort by sum of a field 1
A03 - count in report footer gives me #Error? 0
sort report results by a custom field 1
automatically emailing reports to users 1
Group by year, then by total 1
NPR music station. 3
using "yes/no" field to sort report data and create subtotals & to 9

Top