Converting a Concatenate Query

This worked in Access, but I'm not sure how to convert it for use in SQL
2000:
Concatenate("SELECT Abbreviation FROM TblChargesDetailed
WHERE CaseNmbrID =" & [CaseNmbrID])
Basically, the Concatenate code takes a list of items in another table
and strings them into a single field separated by commas.
Thanks!Cheryl,
This sort of thing should really be done at the presentation layer.
But, if you must, have a look at:
http://www.aspfaq.com/show.asp?id=2529
-Andy
"Cheryl" <Cheriiac@.hotmail.com> wrote in message
news:ekJLGh4PFHA.2788@.TK2MSFTNGP09.phx.gbl...
> This worked in Access, but I'm not sure how to convert it for use in SQL
> 2000:
> Concatenate("SELECT Abbreviation FROM TblChargesDetailed
> WHERE CaseNmbrID =" & [CaseNmbrID])
> Basically, the Concatenate code takes a list of items in another table and
> strings them into a single field separated by commas.
> Thanks!|||See if this helps:
http://sqljunkies.com/WebLog/amacha...11/10/5065.aspx
AMB
"Cheryl" wrote:

> This worked in Access, but I'm not sure how to convert it for use in SQL
> 2000:
> Concatenate("SELECT Abbreviation FROM TblChargesDetailed
> WHERE CaseNmbrID =" & [CaseNmbrID])
> Basically, the Concatenate code takes a list of items in another table
> and strings them into a single field separated by commas.
> Thanks!
>