[AccessD] Mailing Labels

On 21 Jun 2006 at 13:14, Robert L. Stewart wrote:

> Essentially, you will pass in the ID, 1234, and return all of the names in a
> comma separated list.  Your query would look something like this:
> 
> SELECT
>     NameID, GetNameList(NameID), Address
> FROM
>     YourTableName

Try:

 Select Distinct
           NameID, GetNameList(NameID) as NameList, First(Address) as Addr
 FROM
     YourTableName

> You would need to build the function GetNameList.

This one has been discussed before, search the archives for "concatenate"


-- 
Stuart