Crosstab Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a crosstab that concatenates text? This is what I'm
trying to do:

Table 'Allergies':
CamperID, CampID, Allergy
1, 1, Asthma
1, 1, Bees
1, 1, Poison Ivy

-------------------------

Crosstab Query 'AllergiesByCamper':
CamperID, CampID, Allergies
1, 1, 'Asthma Bees Poison Ivy'

I appreciate any help you may provide.

PS - any idea when the Access 2007 runtime will be available?
 
Thank you for your help - the function was right on! A little tweak here and
there and this thing will be up and running! Thanks again.
 
Back
Top