Odd dollar field 1

[jpl458]

I am working with a non-microsoft type database, and in certain tables it store currency in the form 150;0;0;0;0;0;0;0;0. The Dollar and cents are in the left part of the field, so I want to strip everything to the right of the currency amount (all those semi-colons and zeros. Is there some sort of strip function, or else how would this be done in the QBE grid.

The money part can be from 1 to 7 character including decimal point. The field in the database is text. Using access 2010 via odbc, which works very well.

Thanks in aadvance

 

[PHV]

you may try this:
Left(CurrencyField, InStr(CurrencyField,';')-1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886