Options buttons, top 25% value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that shows a listing of clients and what we invoiced them for
the year. Clients are grouped together by a Group code and I Show a total
for those clients that are members of a group.

I have a form where the user selects the fiscal year they want to report on.
There are also 2 option buttons on the form.. They can choose to see
invoice totals for both the Group and individual clients or just the invoice
totals by Group. All of this works beautifully.

I would like to add an addidional option button that allow this report to be
run for the top 25% of our clents.

How do I do this?

Thanks!
 
Are you using a query for this? If you are, then you should be able to use a
condition in which you get the max of all the records in the field you want
to group by, then use a statement like:
0.75*Max([TableName]![FieldName])
Click to expand...
 
Back
Top