how to identify what value has a max occurence in a report/query

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

Guest

I have a simple report with fields such as Day, Product, Thrown Out Qty, and
Reason.

For some period the same reason (e.g. cutt off) can occure many times.

How could I identify which reason has a max frequency in the records?
(I would highlight these rows with some color.)

Thanks
 
Thanks a lot everybody. I've already resolved it.
I found the answer searching the topic.

Create a query that includes the zipcode field twice. Click on the sigma
(looks like E) button on the toolbar at the top of the screen. Under ONE of
the zipcodes, change Group By to Count. Run the query and you will get
something like:
Zip1 5
Zip2 3
Zip 3 7
Zip4 1
Zip5 9
 
Back
Top