FieldName: [firstname] & " " & [lastname]
For FREE Access ebook and videos click here http://access-databases.com/ebook --- In [email protected], "jay" <jtris...@...> wrote: > > Help wanted: separate a full name string with comma in string into > first name and last name. > > Need a query statement that will parse a [FULL NAME] field > containing "last,first" name into a two other field [fisrt] and [last] > in the same table. > > Thanks and Happy Holidays > Jay >
