Sorting and Grouping Help Needed!!

[Guest]

I have a report that is grouped by a fieldname called "Group_Name".
It is listing the Group Names by alphabetical order. However, I want the
grouping to be sorted by my own choice. We have a meeting agenda that has
group names that are not in alphabetical order. How do I program the reports
to group by:

"W2K3", then
"BlackBerry", then
etc..

Thanks

Ben

 

[Douglas J. Steele]

You'd have to have another table that indicates the desired sort order, join
that new table to your existing query and sort by the appropriate field from
that new table.

 

[Guest]

IMHO, the optimum solution is to add a field to your table of group names
that identifies the sort order.

If you can't or won't do that, you can use a expression in the sorting and
grouping like:
=Instr("W2k3,BlackBerry,...", [Group_Name])
This expression would require manual maintenance when values change.