Crosstab Help

[Doug]

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?

 

[Allen Browne]

To concatenate the text of the related items into a string, use a function
like this one:
http://www.mvps.org/access/modules/mdl0004.htm

The A2007 is out now:
http://www.microsoft.com/downloads/...D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en

 

[Doug]

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.