Application Center Administration - extracting variable length string of text from a field

This is Interesting: Free IT Magazines

Home > Archive > Application Center Administration > January 2005 > extracting variable length string of text from a field

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

extracting variable length string of text from a field

mpost1123

2005-01-30, 8:48 pm

In Access 2003 db I have a field [Fullname] with customers' names: last
names, followed by first names plus occasionally other middle names; there
are no commas in the field. Last names obviously variable length. How do I
use Left function to return just the last name, i.e. all characters up
through first blank space?