Hello,
I have a table:
[ID][DATE][Choice][Quantity]
The person gets to come back as often as possible and choose between 3 different items, A, B C, for the [choice] column. They can take as many as they want, [Quantity] column.
I want a query that groups by id, giving me a count of A., Count of B and Count of C choices. Then I want to have a sum of each quantity.
I am not able to figure out how to get a count of each choice type per ID.
Any ideas?
Please and Thanks
I have a table:
[ID][DATE][Choice][Quantity]
The person gets to come back as often as possible and choose between 3 different items, A, B C, for the [choice] column. They can take as many as they want, [Quantity] column.
I want a query that groups by id, giving me a count of A., Count of B and Count of C choices. Then I want to have a sum of each quantity.
I am not able to figure out how to get a count of each choice type per ID.
Any ideas?
Please and Thanks
Comment