build an expression in Access query 2003

  • Thread starter Thread starter loucherry
  • Start date Start date
L

loucherry

What expression could I put together to use in an update query that
would
return a string that ends in a space. The target string would be the
first
string appearing in the field. exmp: [Name] Louis W. Cherry. Target
string
is Louis. I wish to put it into [First Name] field.
Lou
 
Back
Top