Revove decimal if two in field

[itownson1]

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

 

[theDBguy]

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.

 

[sxschech]

Edit your query for the field something like:

NoDec1:iif(left(fieldname,1)=".",mid(fieldname,2),fieldname)

 

[itownson1]

Once again, thank you very much. Worked perfectly.

 

[theDBguy]

Once again, thank you very much. Worked perfectly.

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.