B
Brad
I want to design a report that groups by an expression for an Amount field.
E.g., the first group would be >20000, the next group 10000 to 19999, and
the last < 10000. Inside each group is a name field that's sorted
alphabetically. It might look like this:
----------------------------
Amounts as of September, 2003:
20,000+:
Alice 23,000
Carl 27,000
Janice 21,000
10,000 to 19,999:
Bob 18,000
John 11,500
William 15,000
<10,000:
David 4,500
Ken 375
Ron 2,500
Ted 7,250
----------------------------
As you can see, the amounts are not sorted within each group because it's
sorted on the name.
I don't know how to do the groups by expression, so perhaps someone can help
me with that. If I can find out how to do that, I may be able to figure out
the rest. Still, I'll take any help I can get with any/all of it, as I'm a
newbie and figure things out slowly. Thanks for any help.
Brad
E.g., the first group would be >20000, the next group 10000 to 19999, and
the last < 10000. Inside each group is a name field that's sorted
alphabetically. It might look like this:
----------------------------
Amounts as of September, 2003:
20,000+:
Alice 23,000
Carl 27,000
Janice 21,000
10,000 to 19,999:
Bob 18,000
John 11,500
William 15,000
<10,000:
David 4,500
Ken 375
Ron 2,500
Ted 7,250
----------------------------
As you can see, the amounts are not sorted within each group because it's
sorted on the name.
I don't know how to do the groups by expression, so perhaps someone can help
me with that. If I can find out how to do that, I may be able to figure out
the rest. Still, I'll take any help I can get with any/all of it, as I'm a
newbie and figure things out slowly. Thanks for any help.
Brad