Need to count number of times in a room

[mkb-bf]

I have a database that tells me a name and what room was used among other data. I need to count how many times each room was used. As a newbie in Access I have been unable to solve this query. Could someone please help as to what I need to do to get an acurate count of numbers of times room was used.
Thanks in Advance for your help!

 

[pbaldy]

Something like:

SELECT RoomField, Count(RoomField) AS HowMany
FROM TableName
GROUP BY RoomField

 

[mkb-bf]

Got It!!!

Thank you so much!