CCBtx Posted February 4, 2011 Share Posted February 4, 2011 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 More sharing options...
CCBtx Posted February 4, 2011 Author Share Posted February 4, 2011 I think I answered my own question: Sum(field). So Simple Link to comment Share on other sites More sharing options...
comment Posted February 4, 2011 Share Posted February 4, 2011 Is it? Link to comment Share on other sites More sharing options...
CCBtx Posted February 4, 2011 Author Share Posted February 4, 2011 Well.... yes, particularly when you consider I had a very similar problem several months ago... and the answer was the same. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4830 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 accountSign in
Already have an account? Sign in here.
Sign In Now