I want to return all characters in a filename before the dot.
J John Spencer Jan 3, 2008 #2 Left([FileName],Instr(1,[FileName] & ".",".")-1) -- John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County ..
Left([FileName],Instr(1,[FileName] & ".",".")-1) -- John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County ..
