Sorting on a Calculated Field in a Report

  • Thread starter Thread starter Jessica
  • Start date Start date
J

Jessica

I have created a field in a report that is calculated. I want to sort the
calculated numbers in that field from high to low. Is that possible?

Exp.

=Sum([Boat Price])

Can I sort on this field?
 
Jessica said:
I have created a field in a report that is calculated. I want to sort the
calculated numbers in that field from high to low. Is that possible?

Exp.

=Sum([Boat Price])

Can I sort on this field?
Click to expand...


You could if it were a field.

What you have is a text box control with an expression and
because the value of the expression is calculated within the
report, the report can not organize the data by values it
has to calculate later.

To do what you want, you need to calculate the total in the
report's record source query. This can be easy or difficult
depending on the tables, fields and type of those fields
that you want to include in the report.
 
Back
Top