I have a table which contains four records. On one field, I would like to
take all four records in that field and combine them into one new field: i.e.
existing field test1 has 4 lines of data. I want to put those 4 lines of data
into 1 new field called test2 but also want them to separated by a carriage
return!

Any help would be greatly appreciated - ty.

I'm not sure whether or not I understand your question, but here goes...

You have a table, with 4 records, and we will assume 10 fields. You want to
take the value, for the 4 records, in one(1) of those fields, and combine
them in to a single record, in a single field.

Did I get that right?

Here is how you may be able to do this. I don't stand by it because the
response came from another person, on this newsgroup, and I've never actually
done it.

This person suggested using this code structure, to add your carriage returns:

"<text1>" & CrLf & "<text2>", etc.

HTH

Sharkbyte

"baconroll" wrote:

> I have a table which contains four records. On one field, I would like to
> take all four records in that field and combine them into one new field: i.e.
> existing field test1 has 4 lines of data. I want to put those 4 lines of data
> into 1 new field called test2 but also want them to separated by a carriage
> return!
>
> Any help would be greatly appreciated - ty.
>
>

That is exactly whate I wanted - tyvm.

"Sharkbyte" wrote:

> I'm not sure whether or not I understand your question, but here goes...
>
> You have a table, with 4 records, and we will assume 10 fields. You want to
> take the value, for the 4 records, in one(1) of those fields, and combine
> them in to a single record, in a single field.
>
> Did I get that right?
>
> Here is how you may be able to do this. I don't stand by it because the
> response came from another person, on this newsgroup, and I've never actually
> done it.
>
> This person suggested using this code structure, to add your carriage returns:
>
> "<text1>" & CrLf & "<text2>", etc.
>
> HTH
>
> Sharkbyte
>
> "baconroll" wrote:
>
> > I have a table which contains four records. On one field, I would like to
> > take all four records in that field and combine them into one new field: i.e.
> > existing field test1 has 4 lines of data. I want to put those 4 lines of data
> > into 1 new field called test2 but also want them to separated by a carriage
> > return!
> >
> > Any help would be greatly appreciated - ty.
> >
> >