How to group text?

  • Thread starter Thread starter shopper
  • Start date Start date
S

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?
 
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?
Click to expand...

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!
 
Back
Top