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.
This conversation is currently closed to new comments.
You can only sort on the main fields of the reports, so a work round could be to generate a query for your main report which totals the sub-client totals for each main client and use that as a hidden field to sort on. Query1: main extract query, eg: Main client details. Query2: sub-totals query, with ClientID and totals only Query3: Merge Query1 and Query2 possibly with a outerjoin Design report on Query 3 and sort on the totals column, but hide the field. You can insert the sub-clients asa sub-report and still total these.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Access97 Sorting
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.