Hello,

I am trying to sort groups, but am having difficulties with how to set it up.  I need to sort based on a category called "Acronym" which shows an alphanumeric course designation (it is for seminars that are generally 2-5 days in length).

I need to group the records by the acronym, but I need to sort the groups chronologically by the dates in which the seminars are run.

As it turns out, we sometimes run more than one class on a given set of dates.  I've been able to either group and sort by acronym (not in correct date order), or by date (then the grouping collapses all courses run on the same date into one).

Access seems to be able to do this, but I can't figure out how to do it in Crystal.

Thanks for any help you can offer!


Edited by FrederickMeyer - 15 Oct 2009 at 4:49pm

That worked!  Thank you!

I'm not really sure why it worked though (or, how).  What exactly does this formula do differently than grouping on either the acronym field or the date field?  I'm just trying to learn more about how Crystal works...

Thanks again!