Select Left Most Word in a field

[David Bailey]

I have a field that contains a peoples full names, first name and surname in the same field (not my design) and need to build a query that extracts the left most word (being the surname). Obviously the with the LEFT function you have to specify the number of letters but this may vary

Any ideas anybody?

 

[Sohaila Taravati]

Try this link:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q115915

 

[Fizzio]

Look up the instr function. essentially you want to use a combination of Left and Instr eg

Surname: Left([YourField],InStr([YourField]," ")-1)