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