concatenation

C

confused

i have two fields (subject1 and subject2), i want to
concatenate these two fields and to eliminate confusion i
want to concatenate subject2 on a new line instead of
just a space between the 2 fields. how can i do this?
another question is that, can i still use the wildcard
char (*) when i invoke filter by form with this
concatenated field?

thanks in advance.
 
S

Steve Schapel

Confused,

[Subject1] & Chr(13) & Chr(10) & [Subject2]

And yes, the * can still be applied.
 
G

Guest

thank u so much.
-----Original Message-----
Confused,

[Subject1] & Chr(13) & Chr(10) & [Subject2]

And yes, the * can still be applied.

--
Steve Schapel, Microsoft Access MVP

i have two fields (subject1 and subject2), i want to
concatenate these two fields and to eliminate confusion i
want to concatenate subject2 on a new line instead of
just a space between the 2 fields. how can i do this?
another question is that, can i still use the wildcard
char (*) when i invoke filter by form with this
concatenated field?

thanks in advance.
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top