combine name columns

[Mike Hughes]

NEVER MIND--- I FIGURED IT OUT

I have a table with two columns.
FIRST LAST
James Jones
R Kevin Foster

When I use this:

Left(FIRST,1) & " " & LAST AS Expr1

I get: James Jones
R Foster

Is there a way to correct this so R Foster comes back as R Kevin Foster?

 

[neileg]

?

Using Left as you do means you you only get the first character of FIRST. I don't see how this could return James Jones, it should be J Jones.

If you want the whole name you should use
FIRST &" " & LAST

If your field names really are FIRST and LAST, you should change them since both are reserved words in Access. This can have unpredictable results.

 

[Bodisathva]

(FIRST & " " & LAST)

what I don't get, is that Left(FIRST,1) & " " & LAST AS Expr1 should NOT produce James Jones

EDIT: never mind...neileg beat me to it