Query...

[Ivan Debono]

Hi ppl,

I have a main table A and a table B. I would to select all records in table
B that match their id in table A, but instead of having the results in a
list, I would like them comma separated in 1 line, example:

I have the following values:

Table A
1, Item 1
2, Item 2

Table B
1, 1, Monday
2, 1, Tuesday
3, 1, Wednesday
4, 2, Thursday
5, 2, Friday

My results after the query would be:

Item 1 Monday, Tuesday, Wednesday
Item 2 Thursday, Friday

Can I do it, and if yes, how??

Thanks,
Ivan

 

[Duane Hookom]

THere is a generic concatenate function and sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane