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
you can use many nested expressions to form your basis?

John Spencer wrote:
Easiest way if your string contains only one comma.
Mid(SomeString,Instr(1,SomeString,",")+1)

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

Hello,

[quoted text clipped - 13 lines]

Thanks!

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