Jump to content

# Summing trouble pt 2, the revenge

This topic is 7160 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

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.

##### Share on other sites

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.

##### Share on other sites

This topic is 7160 days old. Please don't post here. Open a new topic instead.

## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account

## Sign in

Already have an account? Sign in here.

Sign In Now
×
×
• Create New...

## Important Information

By using this site, you agree to our Terms of Use.