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!

Something like:

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

Thank you so much!