If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to identify what value has a max occurence in a report/query
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 |
#2
|
|||
|
|||
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 "Alex" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Identify Label — More than one cell with label | George Lynch | General Discussion | 2 | May 4th, 2005 05:12 PM |
MATCH Function based on specified occurence (i,e return position based on 2nd occurence) | [email protected] | Worksheet Functions | 3 | December 10th, 2003 02:12 PM |
Find second occurence | Steved | Worksheet Functions | 5 | October 5th, 2003 09:16 PM |