Jump to content

How to search for a summed amount


CCBtx
 Share

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

Recommended Posts

I am havinga terrible mental block here.

I have a table that has 2 fields, account and amount.

For example

1 15.00

1 32.00

1 96.00

1 2.00

2 86.00

2 45.00

2 23.00

3 25.00

3 10.00

...and so on where 1, 2 and 3 are the account numbers

I am trying to produce a summary report layout where I have 1 line per account with the sum of the amounts... but I ONLY want to list accounts that sum to > 50

So, with this example, my report should look like

Account Total Amount

1 145.00

2 154.00

...notice no account 3 because its sum is not >50.

I am fairly sure I can do this with a single box portal line sorted largest to smallest.... but I was thinking there may be a more straight forward way with relationships or something else.

Thanks for your help.

Link to comment
Share on other sites

This topic is 4386 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
 Share

×
×
  • Create New...

Important Information

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