Merging multiple Text fields into one Memo field

[Cheryl Fischer]

Try ...

[Notes1] & Chr(13) & Chr(10) & [Notes2] & Chr(13) & Chr(10) & etc.

hth,

 

[Jacko]

I have inherited a database at work that has a notes box on a form. However,
instead of being a single Memo field, the notes is actually 8 separate text
fields, Notes1, Notes2.... etc. I would like to merge all these separate
text fields into a single memo field. I know how to run an update query to
merge them using the & sign to join two strings together, but how can I
force a carriage return (new line) after each field has been joined, so that
each text field would have it's own line in the resulting memo box on a
form? I would be grateful for any help. Jacko

 

[Cheryl Fischer]

You're welcome and happy holidays to you.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Thanks Cheryl. I just did a test and your solution worked like a dream.
Happy Christmas. Jacko.

Try ...

[Notes1] & Chr(13) & Chr(10) & [Notes2] & Chr(13) & Chr(10) & etc.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I have inherited a database at work that has a notes box on a form. However,
instead of being a single Memo field, the notes is actually 8 separate text
fields, Notes1, Notes2.... etc. I would like to merge all these separate
text fields into a single memo field. I know how to run an update

query

to so
that

 

[Jacko]

Thanks Cheryl. I just did a test and your solution worked like a dream.
Happy Christmas. Jacko.

Try ...

[Notes1] & Chr(13) & Chr(10) & [Notes2] & Chr(13) & Chr(10) & etc.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I have inherited a database at work that has a notes box on a form. However,
instead of being a single Memo field, the notes is actually 8 separate text
fields, Notes1, Notes2.... etc. I would like to merge all these separate
text fields into a single memo field. I know how to run an update query to
merge them using the & sign to join two strings together, but how can I
force a carriage return (new line) after each field has been joined, so that
each text field would have it's own line in the resulting memo box on a
form? I would be grateful for any help. Jacko