parsing name into two fields

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
 
C

Cheryl Fischer

Hi Judy,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i separate an address field into three fields Access 2007 7
Joined field is blank 1
Split the contents of a field ie - full name into first and last n 3
Parsing Full Name and Title/degree 7
split full name(last, first) to last name and first name fields 3
Access 2003: How to split one (lastname, firstname) field into 2? 2
Table design 7
Problems mergeing two text fields 5

Top