Combine Text Fields in Query

[TLW]

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]

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]

Yes, that did the trick. Thanks for your help!!

 

[R. Hicks]

You are welcome ......

RDH