how do i sort my data by a report field (override query sort)? (1 Viewer)

starfailure

New member
Joined
Jan 4, 2002
Messages
8
this is probably really easy to do, but for some reason, i can't get it. i have a report field (like, a calculation of two fields in a query), but i can't get the report to sort by that field.
 

Rod C

Registered User
Joined
Dec 19, 2001
Messages
41
Open your report in design view. Make sure the Formatting tool bar is on. Click the Sourting and Grouping button. You will see a popup that will help you with this.
 

Pat Hartman

Super Moderator
Staff member
Joined
Feb 19, 2002
Messages
28,546
You can't sort by a field that is calculated by the report for obvious reasons. If you want to sort by something calculated, SalesTotal for SalesPerson for example, you'll need to create a totals query that calculates the total for each SalesPerson and then join that query to the one used as the recordsource for the reports. That way the SalesTotal will be a field in the report's recordsource and then you can sort on it so the the SalesPeople are listed in order by their SalesTotals.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom