Another Sorting by calculated field question???

[Apollo6]

I have looked through the different threads but haven't found a match for my problem...

I have a report that is built and sorted by a Regimen_Code - ASC. Regimen_Code is a string. I have a total margin for regimen drugs on the report. I also have a subreport that calculates total regimen delivery margins for those regimen_codes. Below that, I have a calculated field that combines the total from the main report and the total from the subreport to give me a grand total margin for the regimen_code. I need to figure a way to sort this GrandTotal_Margin in descending order. Is this possible to do on the report itself???

Thanks for any suggestions.

 

[dhookom]

This can't be done in the report. You would need to calculate this in a separate query or function that can be included in your report's record source.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.