Hello,
I have a report I'm importing into Access where I need to generate a a count of unique reservations rather than just a count of people at the table for each unique table type.
I.e. if I have the following table:
I am trying to construct a query that will return the following:Code:Table | Reservation | Name Banquet | 1 | Larry David Banquet | 2 | Jeff Garlin Banquet | 2 | Suzie Yellsalot Banquet | 3 | Marty Funkhowser Banquet | 3 | Miss Funkhowser Group1 | 4 | Jason Alexander Group1 | 5 | Elaine Bennis Group1 | 6 | Jerry Seinfeld Group1 | 7 | Kramer Group2 | 8 | Thomas Jefferson Group2 | 8 | Martha Jefferson Group2 | 8 | Edith Jefferson Group2 | 9 | Ronald Reagan
I am able to get the count of one or the other using SELECT DISTINCT. Is there a way in a single query to get the count of distinct reservations for each distinct Table?Code:Table | # of Reservations Banquet | 3 Group1 | 4 Group2 | 2
Any help would be greatly appreciated