Grouping - Help on How to Group Something

K

Karin

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.
 
K

KARL DEWEY

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))
Click to expand...
--
KARL DEWEY
Build a little - Test a little


Karin said:
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.
Click to expand...
 
K

Karin

Exactly what I needed. Thank you.

KARL DEWEY said:
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))
Click to expand...
--
KARL DEWEY
Build a little - Test a little


Karin said:
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.
Click to expand...
Click to expand...
 
Top