Revove decimal if two in field

itownson1

Registered User.
Local time
Yesterday, 22:41
Joined
Mar 20, 2019
Messages
43
I am trying to remove a decimal if it is the first character in a field.
We get weights from a set of scales that appear as .2.450 which is 2.45kg.
When manually entered there is no leading decimal so trim is not an option.
Ian
 
Hi Ian. Have you tried using Left() to check for a dot? Or, you could also try InStr(). However, both functions require a String value.
 
Edit your query for the field something like:
Code:
NoDec1:iif(left(fieldname,1)=".",mid(fieldname,2),fieldname)
 
Once again, thank you very much. Worked perfectly.
 

Users who are viewing this thread

Back
Top Bottom