Hiya,
I'm trying to find out which one is the popular food.
So in my table I have a field name called FOOD and listed in it, is cake, biscuits, apples, carrots.
How in the query would I rank the highest to lowest to see which one mostly put?
Thanks