S
swjunkie
This may already be answered elsewhere, but I couldn't seem to come up with
the right search words to locate it.
I have a database for season ticket holders. I have one table
(TicketHolderData)that holds the personal data for the ticket holder (name,
address, etc.) which has primary key CustID. I have another table
(TicketHolderSeats) that has field CustID linked to the first, and then
contains the seats in fields Section, Row, and Seats. Some ticket holders
have multiple rows in this table depending on how many sets of seats they
hold. I am trying to create a query that will hold all of the personal data,
plus the concatenated data on each set of tickets. I currently have a query
showing me each row from TicketHolderSeats on a separate line with the
correct personal data on each line. Is there a way to make the query combine
them into one field on one line (i.e. "Section A, Row C, Seats 9-14; Section
D, Row Q, Seats 18-19")? Thanks for any assistance!
the right search words to locate it.
I have a database for season ticket holders. I have one table
(TicketHolderData)that holds the personal data for the ticket holder (name,
address, etc.) which has primary key CustID. I have another table
(TicketHolderSeats) that has field CustID linked to the first, and then
contains the seats in fields Section, Row, and Seats. Some ticket holders
have multiple rows in this table depending on how many sets of seats they
hold. I am trying to create a query that will hold all of the personal data,
plus the concatenated data on each set of tickets. I currently have a query
showing me each row from TicketHolderSeats on a separate line with the
correct personal data on each line. Is there a way to make the query combine
them into one field on one line (i.e. "Section A, Row C, Seats 9-14; Section
D, Row Q, Seats 18-19")? Thanks for any assistance!