View Full Version : Combine Text Fields in Query


TLW
09-17-2001, 05:28 AM
I am attempting to combine two text fields into one field in a query. My problem is that spaces are placed between the strings from each field when they are combined. EX:
"B0034" is being combined with "QSLP", when combined it appears B0034 QSLP when I need it to appear like B0034QSLP. Any help would be appreciated.

R. Hicks
09-17-2001, 05:43 AM
Unless your expression is adding the space it should not be there. It is possible the the second field contains a leading space so try this:

Exp: Trim([NameField1]) & Trim([NameField2])

Trim() will remove leading and trailing spaces if they exist.

HTH
RDH

TLW
09-17-2001, 06:47 AM
Yes, that did the trick. Thanks for your help!!

R. Hicks
09-17-2001, 08:06 AM
You are welcome ...... :-)

RDH