Sort by Computed column within group

[bicit]

Does any have a good method for sorting on a grouped column within a footer? For example, I would like to grab the total values by group, stick it in the group footer, and then sort the report by it..
I was thinking that this could be done within the sql select somehow, but not quite sure(running Access off of SQL 2000)
Thanks.

 

[dhookom]

You would create a totals query that is similar to your report's record source. Group the totals query by the Group from the report so you can calculate the appropriate totals in the query. Then, add this query to your report's record source so you can sort by your calculated total from the totals query.

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