Grouping by Value

[AccessGirl]

I am designing a report, and I want it to show the stratification by amount.
For example, if we have:

PO#123 $1000
PO#234 $500
PO#345 $250
PO#456 $10
PO#567 $10000

I want it to group them by
Grouping Count Sum
$0 - $100 1
$101 - $500 2
$501 - $1000 1
More than $1000 1

Is there a way to do this?

 

[Allen Browne]

Create a table containing the ranges, and then use the logic that Tom
Ellison provides in this article:
Lookup in a range of values in a query
at:
http://allenbrowne.com/ser-58.html