Hide a Group of Records based on Criteria?

S

screenwriter776

Hi, Folks -

I have a sales report grouped by [SalesRep].

Is it possible to hide a SalesRep's header & detail records if his
sum([revenue]) is less than 1% of the report's total revenue?

(I only want reps whose sum([revenue]) > 1% of the report's grand
total.)

Any ideas would be much appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count or sum unique records in a report's group footer in Access 2 2
Groups' summary clubbed together 1
Grand Totals In Report Footer for Separate Groups 3
I want to total a particular group 1
Group summation not working 3
Adding Criteria to Access Reports 2
Using "Sum" to add values from records in detail section 8
Count Records in a Group 2nd Request 2

Top