Does anyone have a method of returning a count of significant figures (into a new column)? E.g. 5.00 = 3, 500=1, 122.2 = 4 etc. I am having trouble finding a solution on the web.
Thank you much!
Novice
Windows 10 
Access 2010 32bit
Does anyone have a method of returning a count of significant figures (into a new column)? E.g. 5.00 = 3, 500=1, 122.2 = 4 etc. I am having trouble finding a solution on the web.
Thank you much!
Master of Nothing
Windows 7 32bit Access 2010 32bit
500 has 1 significant figure?? I would say it has 3....? You are counting every character except punctuation (the dot)?
Maybe this?
Best way to do significant, repetitive data entry
Change calculated field result in a query to 3 significant figures
Counting figures between values
Posting Permissions
Reply With Quote