QUery results from lookup wizard

[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

 

[Guest]

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