How to dispay most frequent value on report

BJS

Registered User.
Local time
Today, 15:54
Joined
Aug 29, 2002
Messages
109
I have a report based on a query that is based on criteria entered on a search form I created.

I would like to display the most frequent pay rate for an employee.
E.g: The report displays the following:

John 15.00
Mark 15.00
Jane 20.00
Jan 16.00
Jone 14.00
Jack 15.00

I would like to display 15.00 to be the most frequent pay rate.

Can anyone help with this?
 

Users who are viewing this thread

Back
Top Bottom