How to remove spaces from a name in the name field? 2

[tekvb1977]

I have a table that has two fields:

LName and FName

I am trying to concatenate both fileds like:

Name: [FName] & [FName]

in a query.

However, the expression Name comes back with spaces like

Heather Brooks

How could I get rid of the spaces so that my query shows me

Heather Brooks instead of Heather Brooks

I tried to use the Left function but it's not giving me what I want.

Thanks in advance.

J

 

[SkipVought]

Hi,

Name: trim([FName]) & " " & trim([FName])

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[AlexMidd]

Try the Trim, LTrim and RTrim functions.

Have fun! )

Alex Middleton