Field Concatenation

[Shelly]

I'm not sure this is the right place to post this, but
I'll give it a try...

I have a report and I want to concatenate two fields
together into one with a hard return between. In other
words in one control I want it to show this...

Field1 data
Field2 data

Can I do this? How would I put these together?

Thanks in advance...
Shelly

 

[fredg]

I'm not sure this is the right place to post this, but
I'll give it a try...

I have a report and I want to concatenate two fields
together into one with a hard return between. In other
words in one control I want it to show this...

Field1 data
Field2 data

Can I do this? How would I put these together?

Thanks in advance...
Shelly

As Control Source of an UNBOUND text control:
=[Field1] & chr(13) & chr(10) & [Field2]

Note.. the chr(13) and chr(10) must be in that order.

 

[Guest]

-----Original Message-----

I'm not sure this is the right place to post this, but
I'll give it a try...

I have a report and I want to concatenate two fields
together into one with a hard return between. In other
words in one control I want it to show this...

Field1 data
Field2 data

Can I do this? How would I put these together?

Thanks in advance...
Shelly

As Control Source of an UNBOUND text control:
=[Field1] & chr(13) & chr(10) & [Field2]

Note.. the chr(13) and chr(10) must be in that order.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

Thanks, Fred...my head hurts from banging it against the
keyboard...I should have known that one.

Shelly

 

[NBReceptionist]

how do I do the same thing without the hard return. I want a space between [Field 1] and [Field 2]. I am sure this is as simple as pie, but I'm a brand new user. Thanks for the help!

I'm not sure this is the right place to post this, but
I'll give it a try...

I have a report and I want to concatenate two fields
together into one with a hard return between. In other
words in one control I want it to show this...

Field1 data
Field2 data

Can I do this? How would I put these together?

Thanks in advance...
Shelly

As Control Source of an UNBOUND text control:
=[Field1] & chr(13) & chr(10) & [Field2]

Note.. the chr(13) and chr(10) must be in that order.

 

[NBReceptionist]

I figured it out after much trial and error! I'm still interested in y'alls comments.

how do I do the same thing without the hard return. I want a space between [Field 1] and [Field 2]. I am sure this is as simple as pie, but I'm a brand new user. Thanks for the help!

I'm not sure this is the right place to post this, but
I'll give it a try...

I have a report and I want to concatenate two fields
together into one with a hard return between. In other
words in one control I want it to show this...

Field1 data
Field2 data

Can I do this? How would I put these together?

Thanks in advance...
Shelly

As Control Source of an UNBOUND text control:
=[Field1] & chr(13) & chr(10) & [Field2]

Note.. the chr(13) and chr(10) must be in that order.

 

[fredg]

how do I do the same thing without the hard return. I want a space between [Field 1] and [Field 2]. I am sure this is as simple as pie, but I'm a brand new user. Thanks for the help!

I'm not sure this is the right place to post this, but
I'll give it a try...

I have a report and I want to concatenate two fields
together into one with a hard return between. In other
words in one control I want it to show this...

Field1 data
Field2 data

Can I do this? How would I put these together?

Thanks in advance...
Shelly

As Control Source of an UNBOUND text control:
=[Field1] & chr(13) & chr(10) & [Field2]

Note.. the chr(13) and chr(10) must be in that order.

=[Field1] & " " & [Field2]

 

[NBReceptionist]

Fred, Formual worked perfectly, thanks a billion!