This may be bad database design, but that ship has sailed. I have a table that stores reservations, such as for a hotel or restaurant. I decided the best route to go was create a new record for each room/table reserved. This works beautifully, until one person reserves several rooms or tables. Then I am stuck with several records that are identical save the room or table number. What I am hoping to do is design a query that can make those several records look like one. Meaning I want the query to return just one name, date, username, etc. along with all the room/table numbers. Any ideas on how I can achieve this?