Software

General discussion

Gravatar
Locked

Access97 Sorting

By fritz.pyen ·
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.

5 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Access97 Sorting

by mcthaker In reply to Access97 Sorting

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.

gravatar
Collapse -

Access97 Sorting

by fritz.pyen In reply to Access97 Sorting

The question was auto-closed by TechRepublic

gravatar
Collapse -

Access97 Sorting

by James_Randy In reply to Access97 Sorting

The first answer looks good to me. If that doesn't work, try something else. Hope this helps.

gravatar
Collapse -

Access97 Sorting

by fritz.pyen In reply to Access97 Sorting

The question was auto-closed by TechRepublic

gravatar
Collapse -

Access97 Sorting

by fritz.pyen In reply to Access97 Sorting

This question was auto closed due to inactivity

Back to Software Forum
5 total posts (Page 1 of 1)  

Start or search

Related Forums