Most occurent records (1 Viewer)

[FLabrecque]

I have a table that goes like this (this table tells us what minimum we can order from a supplier):

SUPPLIER PRODUCT ORDER_QTY ORDER_UNITS
SUPP1    CHEESE1 200       $
SUPP1    CHEESE2 200       $
SUPP1    CHEESE3 200       POUNDS
SUPP2    CHEESEA 200       $
SUPP2    CHEESEB 250       CUBES
SUPP2    CHEESEC 200       $

I need to know which conditions are occuring the most for a supplier. I need a list of this table that will tell me what are there "normal" conditions, since it's mostly the same for a specific supplier, except for a few special products.

For example, the output would need to be:

SUPPLIER PRODUCT ORDER_QTY ORDER_UNITS
SUPP1    CHEESE1 200       $
SUPP2    CHEESEA 200       $

You're help will be greatly appreciated!

 

[GabrielR]

Ok, in this case I would create a query on design view with the data in your table and set the query to group by Supplier counting the number of individual orders and ordering the results based on that count.

that way you will get

Supplier Product Count of Orders
SUPP1 CHEESE1 200 3
SUPP2 CHEESEA 200 2

This is just an Idea, you can ellaborate on this a little bit more...