Hello All,

I am having an issue with grouping/sorting. I have an Access Database, with about 70 records. Of these 70 records, I have a field "category", that can have about 14 different "categories", and need to have all these records show.

However, when I select a category in the "select expert", after creating many groups, it only shows that one group. It seems as if I change one of the groups to a different category, it changes them all.

Basically, I need to have a report that shows all these different groups, but separately. I have tried using all subreports, but that will not work for my type of report.

Thanks,
Adrian