On Wed, 18 Jul 2007 23:58:10 -0000,
mo*******@gmail.com wrote:
Is there a way to create a Concatenation Query for 2 columns and at
the same time, remove the spacing between them? The fields that I am
combining are 2 text fields but for some reason there is 15 spaces
between them when I combine.
Evidently your field contains the extra spaces at the beginning of the
data, as concatenation does not add them.
CombineFields:Trim([Field1]) & Trim([Field2])
If you wish at least one space between the 2 fields, then:
CombineFields:Trim([Field1]) & " " & Trim([Field2])
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail