I though this would be easy, but it has turned out not be more difficult that I thought. How can I exclude certain groups that don't meet specified criteria? For example, we maintian a simple time-billing system and we invoice quarterly. However, any customer with less than £100 of billable time on his account gets rolled over to the following quarter. I can produce the reports with totals for each customer (a sub-summary specified by 'customer') with no problem, but how do I then exclude those customers with a total of less than £100 from the quarterly billing report?

Thanks

http://www.onegasoft.com/tools/fastsummaries/index.shtml

There is an example of applying a threshold on this page.

Wonderful! I've had a quick look and this seems to cover exactly my scenario. I'll work through this in detail and see if we can apply it to our situation.

Thanks for pointing my in the right direction.

Reed,

I worked through the tutorial and applied the techniques and I'm pleased to report that this has achieved exactly what I hoped for. Altogether an interesting little exercise with scripts that I couldn't possibly have written myself. Thanks for finding the solution and pointing me to it.

Best wishes,