If I want to parse the last name "Smith" out of the expression "Airtick /
Smith Harry M" how do I use a nested Instr to get my proper length of my
expression? The starting point I have down but in this case the length would
need to be the number generated by the 3rd space minus the number generated
by the 2nd space.

John Spencer wrote:
Sorry, not enough knowledge on my part to understand the question.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Thanks this is helpful. As I get further with other nomencaltures does the
logic for InStr generally work the same as the SEARCH function in excel where
[quoted text clipped - 12 lines]
[quoted text clipped - 13 lines]
Thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/201005/1