G Guest Jan 20, 2006 #1 What's the best way to identify the position of the space in a name. For example, "Bob Jones" would be position 4. Would IIF work?
What's the best way to identify the position of the space in a name. For example, "Bob Jones" would be position 4. Would IIF work?
R Roger Carlson Jan 20, 2006 #2 Actually, InStr would work. dim pos as integer pos = InStr("Bob Jones", " ") -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
Actually, InStr would work. dim pos as integer pos = InStr("Bob Jones", " ") -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
