Large gap in Concatenate 2

[lars7]

Hi,
I keep getting a large gap between the names that I am concatenating like "John Smith" (In access and excel) I tried looking this up but had no luck. Is there a solution to this. Thanks.

 

[PHV]

Have a look at the Trim function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lars7]

Hi PHV,

I didn't know "If trim" could be used in queries but I had a go and got "wrong number of arguments message".

EmployeeName: IIf(trim([surname] & "" & [forename]))

I think it's looking for a "then" but I got an Syntax message with that.

I'm sure this a pretty poor effort but I haven't seen this done before.

 

[straybullet]

EmployeeName:Trim([surname]) & " " & Trim([forename])

The trim just removes spaces - no need for the Iif

Let them hate - so long as they fear... Lucius Accius

 

[lars7]

If I had just left out the "IIf" it would have worked, DOH!


EmployeeName: Trim([surname]) & " " & ([forename])


Thanks Stray and PHV.