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
 
You must log in or register to reply here.

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

Auto number in reports 4
Min and Max for Date Range in Report 4
Identify the row in which a MAX number in a column resides 7
Query String on a Report 2
Identifying records from a query that to be developed in a report 1
Error Procedure running when no error occurs 8
Report Field Problem 3
Can't create a report from my query in Access 1

Back
Top