How to group text?

[shopper]

Hello.

I have two tables in Access 2000 to describe a product. The first has
exactly one record for each product. The second table contains one or more
records for each product. Each of these records is one line of the product
description.

I have developed a query, which combines the two tables, but I am not able
group the text records to one complete text.

Can anyone help?

 

[John Vinson]

Hello.

I have two tables in Access 2000 to describe a product. The first has
exactly one record for each product. The second table contains one or more
records for each product. Each of these records is one line of the product
description.

I have developed a query, which combines the two tables, but I am not able
group the text records to one complete text.

Can anyone help?

see Dev Ashish's sample code at

http://www.mvps.org/access/modules/mdl0004.htm

It will let you concatenate multiple records into a single string.

You may want to consider using a Memo field for the description rather
than breaking up the description into multiple records!