Sorting by =Count() expression

  • Thread starter Thread starter code_hungry
  • Start date Start date
C

code_hungry

Hi,

I have a report that has a =Count([Exposure]) text box. Management asked me
to sort the report by this value. It's giving me a major headache for I
cannot find any website with the answer. Is it possible to sort the report by
the result of this expression?

Things to consider: I only have labels in the Headers., and all data sources
are in the Detail area, including the expression.

Thanks
 
You can only sort a report by values that can be computed from a single
record in the report's record source.

The solution has been posted at least monthly in this forum. Create a
totals/group by query that calculates the Count(). Add this new query to your
report's record source and joins that appropriate fields. You can then use
the count field/column to sort.
 
Back
Top