Grouping - Help on How to Group Something

[Guest]

Hi, I have a query that provides the data I want to report on. I want to
group by the field [BudgetFee] - Group 1: if >24999, Group 2: >14999 and
<25000, Group 3: <15000. Then I'll do a total in the footer for each group.
I can't figure out how to set up the grouping. Any help appreciated. Thank
you.

 

[Guest]

Create a calculated field in your report query then group on that field.
SortGroup: IIF([DataField] >24999, 1, IIF([DataField] >14999 and

25000, 2, 3))

--
KARL DEWEY
Build a little - Test a little

Hi, I have a query that provides the data I want to report on. I want to
group by the field [BudgetFee] - Group 1: if >24999, Group 2: >14999 and
<25000, Group 3: <15000. Then I'll do a total in the footer for each group.
I can't figure out how to set up the grouping. Any help appreciated. Thank
you.

 

[Guest]

Exactly what I needed. Thank you.

Create a calculated field in your report query then group on that field.
SortGroup: IIF([DataField] >24999, 1, IIF([DataField] >14999 and

25000, 2, 3))

--
KARL DEWEY
Build a little - Test a little

Hi, I have a query that provides the data I want to report on. I want to
group by the field [BudgetFee] - Group 1: if >24999, Group 2: >14999 and
<25000, Group 3: <15000. Then I'll do a total in the footer for each group.
I can't figure out how to set up the grouping. Any help appreciated. Thank
you.