var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.......
SELECT Colour, Count(*)
GROUP BY Colour
Thank you so much