concatenate several of records in a field to 1 record

[thread]

Hi all,
what is the best way to concatenate several of data records in a field
into 1
for example
i have the field named animal
and inside i have bird,dog and a cow
how can i concatenateall of them to have 1 field called bird,dog,cow?

 

[Joan Wild]

Have a look at either
http://www.mvps.org/access/modules/mdl0004.htm
or
http://www.mvps.org/access/modules/mdl0008.htm
depending on your setup.

 

[thread]

thanks
Joan Wild :

Have a look at either
http://www.mvps.org/access/modules/mdl0004.htm
or
http://www.mvps.org/access/modules/mdl0008.htm
depending on your setup.