QUery results from lookup wizard

I

ingalla

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
 
K

KARL DEWEY

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top