Sorting on 4 Groups 2

[RobNauticus]

Hello All,
CR 10 / Access 2003

I have four groups:
Group1: DivisionID
Group2: SQFT
Group3: Plan_Number
Group4: Community_Number

Is it possible to sort on Group3 Prior to Group2 without re-arranging the grouping? I need the order of the groups to stay intact, but the data is all jumbled because the Plan_Number is too low in the grouping. Group2 is hidden so I would like to see group3 in some sort of order.

The reason for group2 is to prevent duplicate plan numbers from being incorrectly grouped if the SQFT (Group2) is different.

Any guidance would be awesome!

Thanks,
Rob

 

[BobSuruncle]

Would a better solution be to concatenate the Plan # with the Square Footage?
You could create a new formula to do this and then group on this formula. You'd remove the SQFT and Plan_Number groups.

{Table.Plan_Number} & " - " & {Table.SQFT}

Bob Suruncle

 

[RobNauticus]

I will try that, thanks!

Rob

 

[RobNauticus]

Hello Bob,

I am also attempting to give a count at the Group1 level that would give me the number of unique plans listed in Group3. Any idea on how to easily accomplish this? I do not want to count records only the groups (3) that are showing on the report.

Thanks again,
Rob

 

[lbass]

For the last issue, try:

distinctcount({table.plannumber},{table.divisionID})

-LB