How to concatenate the value of some records from one table into one string?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ta.is.me@gmail.com - 25 Aug 2006 12:40 GMT

Hi all,
i'm just the beginner of MS Access.
could anyone teach me how to concatenate some value from the particular
column of some records(in the table) into one string?
so far, i know only select some records from the table
but i don't know how to concat the value of the data from the column i
want... could anyone please tell me how? ><"

thanks,
starplus ><

Reply to this Message

Wayne-I-M - 25 Aug 2006 20:34 GMT

Hi

Can you give an example of the data you are working with as it sound as if
you may be looking for the wrong answer.

Signature

Wayne
Manchester, England.
Not an expert
Enjoy whatever it is you do

> Hi all,
> i'm just the beginner of MS Access.
[quoted text clipped - 6 lines]
> thanks,
> starplus ><

Reply to this Message