How do I SORT SUBTOTALS in Access97? I want to create a report that ranks clients by revenue. Some clients, however, have many “sub-clients” under them, which make up a total revenue number for the particular client.
I thus want to sort on the TOTAL for each client and want to make sure all the data that is included in the subtotals will stay in tact and “follow” the subtotal when sorted.
