Grouping Expressions

[GraeagleBill]

Can't seem to get group expressions correct. I need two groups:



[LastName] where [field1] = True (Sorted by last name)
[LastName] where [Field2] = True (Sorted by last name)

Then, how do I get to the section properties so I can specify NewRowOrCol for the second of the two groups.

Thanks,
Bill

[June7]

Is this related to:
https://www.accessforums.net/reports...umn-34808.html
https://www.accessforums.net/reports...ter-34814.html

Why do you need grouping expressions?

Are you using the report Grouping & Sorting feature?

Why are there two fields?

Do you want to provide db for analysis?

[GraeagleBill]

I want one group in column 1 and the 2nd group in column 2. I don't know to do that without using Grouping and Sorting. I'm able to specify NewRowOrCol in the group header properties, so that's working.

It's easy to specify a group where [field1] is true and another group where [field2] = true. The problem is that I don't want the groups sorted on [field1] or [field2]. Rather, I want each of the two groups to be sorted on the field [LastName].

[June7]

Don't understand, if you have the grouping working then setting the field for sorting should be simple.

[GraeagleBill]

Sorting is based on the field that defines the group. The problem is how to get the records within the group to sort on the LastName field. Anyway, all our efforts here have gone for naught as my client just called and wants an entirely different format for the report. I'm irritated to say the least...............I would still like to know how to control the sort other than on the field name specified in the Grouping and Sorting.

[June7]

I am using Access 2007/2010.

I have a report that groups by FAAID then by Use then sorts by SectionID. The sorting takes place within the groups. What else would it do?