Avatar of pwdells
Flag for United States of America

asked on 

Trimming a double variable in VBA / SQL.

Quite often, after allocating stock into orders, I get a remaining variable with an amount like this: 9.74100000000001  

How can I just trim the variable to just 9.741 and have it stored in the database field like that?

Thank you in advance!

Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon