Thread: Instr help
View Single Post
  #2  
Old May 19th, 2010, 09:05 PM posted to microsoft.public.access
ghetto_banjo
external usenet poster
  
Posts: 325
Default Instr help

Note that InStr, the string you searching for comes 2nd, not first.



=Right([FieldName],Len([FieldName])-InStr([FieldName],","))