Summing trouble pt 2, the revenge

[BrownFedora]

The tables are related via ContactID

Contact Table Donation Table

ContactID<............>ContactID

Name DonationID

Date

Amount

Total (Summary Field)

We need to sort or find Names that have a subtotal in given ranges (ie given at least $100, $100 to $1000, $1000 to $5000, etc). How could this be done?

I can see subtotals for given names with sub-summaries but I can't not sort or use finds on them. Help will be greatly appreciated.

[-Queue-]

You can use a calculation number field equal to

Case(

Amount > 5000; 4;

Amount > 1000; 3;

Amount > 100; 2;

Amount; 1

)

then search for 1, 2, 3, or 4, etc. or sort by this field.