Combining multiple records into one field for report

  • Thread starter Thread starter Sandra
  • Start date Start date
S

Sandra

I have a table for ticket sales and a table for Patrons.
The ticket sales detail lookup contains only one field as
a number i.e. 101,102,103...
The normal report would look like this:
John Doe (from Patrons table)
Ticket # 101 (multiple records linked to John Doe
Ticket # 102 (in the Ticket Sales table)
Ticket # 103

What I would like to have is:
John Doe Ticket #'s 101,102,103

"Ticket #" is the label, the text box contains the number.
The number of tickets sold to the Patron can vary. I
don't necessarily need this combined in a table just
formatted this way for a printout.
Any way to do this?

TIA,

Sandra
 
Back
Top