How to trim off the filename extension in Access 2000 1

[vamoose]

I am trying to use Trim to remove the filename extension from the following text:

ML16091000.TXT to just ML16091000

The filename is not a constant length but the .TXT is always the same.

Thanks very much.

 

[CautionMP]

vamoose,
[tt]Left("ML16091000.TXT",Len("ML16091000.TXT")-4) = ML16091000
Left("ML16091000.TXT",instrrev("ML16091000.TXT",".")-1) = ML16091000[/tt]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)