View Single Post
Old 01-04-2002, 08:10 PM   #3
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,316
Thanks: 15
Thanked 1,601 Times in 1,520 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
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.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote