QUery results from lookup wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a dropdown box with 3 options, for example option1, option2 and option3

When the user creates a record they select the relevant id, there can be
many records for each id.

CAn anyone tell me how to create a query to count how many times that each
of the options are selected for a particular id.

Thanks

Andy
 
Try this ---
SELECT YourTable.ID, Count(YourTable.ID) AS CountOfID
FROM YourTable
GROUP BY YourTable.ID;
 
Back
Top