computerman29651
IS-IT--Management
Does anyone know how I can sort by one group and then by another alphabetcally?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sorting
- Thread starter computerman29651
- Start date
- Status
synapsevampire
Programmer
Use Report->Sort Records and select the 2 fields.
This depends upon your software version, please post basic information with any post about any software product.
-k
This depends upon your software version, please post basic information with any post about any software product.
-k
Let's say you grouped by ID, but you really want in alphabetical order by the name associated with the ID. Insert a second group on name and then either go to design mode and grab the group#2 in the gray area next to the report canvas and drag it so that it becomes group 1 or go to the group expert and use the arrow keys to toggle it into group #1 position. Then suppress the ID group header.
Another approach is to concatenate the name and ID field, and then group on this, but just display the name field.
-LB
Another approach is to concatenate the name and ID field, and then group on this, but just display the name field.
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question