Sort by color then count of color..

[robbie9]

I am having a brain fart and can't figure this out.. I have a database with kitchen orders in it.. I need to make a Query that sorts the kitchens by color and tells me how many of each color.. Can someone point me in the right direction..

Thanks

 

[ColinEssex]

Hi

Your cerebral problem is one which I can't find in our medical books - you may be the first to name this phenomenon - congratulations!!!!

Count by colour?

New query

Add table

Add colour field twice

switch on totals button (the backwards E on the toolbar)

In totals line change 2nd column to "Count" (from "GroupBy")

Run query

Bobs your Uncle

Col

 

[robbie9]

You are the man... Thanks..