Thanks Steve! That gives me what I needed.
So, here is what I would do.
First, create a one field table named "Options" with a field named "Option".
Add three records to this table, "S", "E", and "D".
Now assuming that your table name is "Data" (modify to suit), this aggregate query will give you what you need:
Code:
SELECT Options.Option, Sum(IIf([Option]=[Counting],1,0)) AS CountingCount, Sum(IIf([Option]=[Multiplying],1,0)) AS MultiplyingCount, Sum(IIf([Option]=[Subtracting],1,0)) AS SubtractingCount
FROM Options, Data
GROUP BY Options.Option;