Bill,

Some of this will depend on what commands your SQL will support. Try using || (pipe) as in SELECT FirstName || LastName AS FullName...



>Is there any way to concatenate character fields from several records in a SQL statement ?
>
>

>Emp    Date        Note
>---------------------------
>1     {1/1/1}      Project 1
>1     {1/2/1}      Assist Kim
>2     {1/1/1}      Sick
>2     {1/2/1}      Project 3
>
>results desired:
>
>Emp   Notes
>---------------------------
>1     Project 1 chr(13) Assist Kim chr(13)
>2     Sick chr(13) Project 3 chr(13)
>

>
>TIA