Thanks Gary....Got the HTTP 404 on the link, but I found the web page with articles noted below...
EXCELLENT!...thanks for the prompt reply. --- In [email protected], "Gary E. Daniels" <gdani...@...> wrote: > > Jay, > > See the article "Parsing - or the Art of Pulling Things Apart" at > http://custom-software.biz/AccessWizard/Dec04.htm. > > Gary > > > > > At 05:15 PM 12/17/2008, you 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 > > > > >
