sorting/filtering data

[nn992]

Hi, I have to make a simple query in access,
here are the pictures which explain what is to be done.








So, I want to achieve somthing like upper picture, but I dont know how to organize it on lower picture...

Thanks in advance...

 

[alansidman]

SELECT YourTable.d, Count(YourTable.d) AS CountOfd
FROM YourTable
GROUP BY YourTable.d

Here is the SQL statement.