asked on
I have a production/stock/invoicing
I have stored quantities throughout the database as numeric(18,4) Within my MsAccess program I have used the Currency data type to manipulate quantity values because this datatype also has 4 decimal places. It has worked well for a few years. I remember from years ago that I encountered rounding errors when using the Single data type. So I was pleased to find that I get none of these with the Currency datatype.
We now have a requirement to store quantities to 6 decimal places. And not wanting to be caught out again in the future I have decided to change all the tables to store values as numeric(18,8). So I also have to change all my code so that to use variables with more decimal places. I think I probably have no choice but to use the Single data type. But I thought I would ask for opinions in here in case there is another option.
I have stored quantities throughout the database as numeric(18,4) Within my MsAccess program I have used the Currency data type to manipulate quantity values because this datatype also has 4 decimal places. It has worked well for a few years. I remember from years ago that I encountered rounding errors when using the Single data type. So I was pleased to find that I get none of these with the Currency datatype.
We now have a requirement to store quantities to 6 decimal places. And not wanting to be caught out again in the future I have decided to change all the tables to store values as numeric(18,8). So I also have to change all my code so that to use variables with more decimal places. I think I probably have no choice but to use the Single data type. But I thought I would ask for opinions in here in case there is another option.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.