M
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
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