Query and Concatenation

[Try2Live4God]

Hello All,

I'm a newb when it comes to VBA.
So please bare with me.....

I have this access 2007 table where I store a database of all my sneakers. I want to be able to concatenate the descriptions/results with the Type of sneaker when the query runs.

So here's my table.



I basically want it to say:
Air Jordan 1 - Leroy Smith 1's & AJKO's
Air Jordan 11 - Spacejams, Playoff's & Anniversary Editions
Air Jordan 12 - Bred's & Playoff's



How do I query this?? Or do I need a VBA for this??

[pbaldy]

This would be one way, with some adaptation:

Return a concatenated list of sub-record values

[thart21]

Hey, I've been working on the same thing so thought I'd send you a zip file of a db I found. Can't remember where I got it but, thanks to whomever posted it. It should do what you're looking for but, as I'm trying it out, I see that it is expecting the ID field (Jordan Number in your case) to be a number format, not text) I'll let you know when I get that fixed. If I change that field to a number, it works perfectly.

Make sure you set a reference to the Microsoft Active X Data Objects library.

Cheers

Found it - here's the link to the forum thread which also explains how to change it to recognize "text"
http://www.access-programmers.co.uk/...ad.php?t=64611
Thanks to Jon K for sharing.