# How to search for a summed amount

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.

##### Share on other sites

I think I answered my own question: Sum(field). So Simple

Is it?

##### Share on other sites

Well.... yes, particularly when you consider I had a very similar problem several months ago... and the answer was the same.

##### Share on other sites

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

## Create an account

Register a new account