QUery results from lookup wizard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ingalla - 30 Oct 2007 23:30 GMT

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

Reply to this Message

KARL DEWEY - 31 Oct 2007 00:39 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> I have a dropdown box with 3 options, for example option1, option2 and option3
>
[quoted text clipped - 7 lines]
>
> Andy

Reply to this Message