Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Posts
    2

    Unanswered: Report from drop down box selection

    Hey.....just can't figure this one out.

    I would like to make a report from the information selected from a drop down box, the drop down box was formed from a look up table.

    I have 6 options and I would like a report to count the number of times each option was selected.

    i.e. red 6, blue 59, etc

    I have a report but it lists red 6 times (red, red, red, red, red, red) and blue 59 times........I can't work out how to make it count them and just return the option and number of times.

    Tried a qry several different ways....but just can't get my head around it.

    Could anyone point me in the right direction please.......

    Thank you
    Noswombat

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    SELECT Colour, Count(*)
    FROM MyTable
    GROUP BY Colour
    George
    Home | Blog

  3. #3
    Join Date
    Jul 2007
    Posts
    2
    Thank you so much

    Cheers
    Noswombat

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •