Count Function in Access SQL Query <p>List the guests by name and the number of times each has reserved a room at one of our hotels. Arrange the list in order from most-frequent to least-frequent guest.</p> <p>I'm keep getting aggregate function for Firstname and LastName</p> <p>So Far i have this code</p> <pre><code>SELECT FirstName, LastName, Count(ResNum) AS TotalReservations FROM RESERVATION, GUEST Where GUEST.GuestNo = RESERVATION.GuestNo ORDER BY RESERVATION.GuestNo </code></pre> <p><strong>And here is the link for the RelationShip Table</strong></p> <p><a href="http://www.mediafire.com/download/7m4ciuxgbb4v8m8/Report1.pdf" rel="nofollow">View Relationship Table</a> <strong>&lt;--- LINK</strong></p>