Sorting and Grouping Help Needed!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
 
Back
Top