parsing name into two fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I changed the name to Full Name and am still
receiving the compile error. I also tried unchecking the
reference table.

SQL view:

UPDATE Parse2Table SET Parse2Table.FirstName = Left
([Parse2Table].[FullName],InStr([Parse2Table].
[FullName]," ")-1);

Thanks to all for the help!
Judy
 
Hi Judy,

If your database can be zipped and emailed, I'd be happy to take a look at
it.
 
Back
Top