query help

[mcnews]

is it possible to create a query that will have a column that will
contain a concatenated value?
my query consists of a couple of joins right now, but the users want
to see a value the will create several redundant rows so they want
this value displayed in one column.
so i'll be using a column found into the existing query to locate all
the occurrences of this value in anpther table to extract the column i
need to cram into one.


COLUMNA COLUMNX As COLUMNC
2008123456 191, 201, 231, 310
2008223311 17, 101, 455
2008321144 201, 455, 477, 478, 479

etc

tia,
mcnewsxp

 

[Jeff Boyce]

I can't tell from your description whether what you showed as an example
illustrates the underlying data you are working from or the final result you
are seeking.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

is it possible to create a query that will have a column that will
contain a concatenated value?

Yes, with a little VBA code. There's a good example at:

http://www.mvps.org/access/modules/mdl0004.htm

 

[mcnewsxp]

lovely
thanks!

Yes, with a little VBA code. There's a good example at:

http://www.mvps.org/access/modules/mdl0004.htm