Combining multiple records into one field for report

[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

 

[Duane Hookom]

Check the generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. The
download has a function and examples of usage.

 

[Sandra]

Thank you so much!

-----Original Message-----
Check the generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hoo kom,Duane. The
download has a function and examples of usage.

--
Duane Hookom
MS Access MVP





.