Position of text within a string

[michael]

I want to return all characters in a filename before the dot.

 

[John Spencer]

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
..