Sorting on a Calculated Field in a Report

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?
 
M

Marshall Barton

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.
 

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

Sort a calculated field 15
Access MSACCESS - Sorting report based on field calculated in the report 0
Sorting text field value in a report 4
Sorting on Calculated Field 5
Sorting a report on a calculated field 1
How do I sort on a calculated field in a report? 8
Sorting by Calculated Field in Report Footer 1
How do I sort by calculated field 1

Top