Results 1 to 2 of 2
  1. #1
    something is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    13

    How in the query would I rank the highest to lowest?

    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

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    assuming 'most popular' means number of food items purchased and you have that value in your table something like


    SELECT FOOD, sum(purchased) as numberpurchased
    FROM tblFood
    GROUP By Food
    ORDER BY sum(purchased)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-21-2015, 02:54 PM
  2. Rank Query
    By cbritt927 in forum Queries
    Replies: 2
    Last Post: 06-02-2015, 04:42 PM
  3. Replies: 1
    Last Post: 02-08-2015, 08:11 PM
  4. Replies: 7
    Last Post: 11-29-2012, 11:36 AM
  5. Query to find lowest value
    By AccessNubie in forum Access
    Replies: 3
    Last Post: 11-30-2009, 07:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums