troubleshooting Question

Which data type to use

Avatar of TownTalk
TownTalkFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Access
6 Comments1 Solution534 ViewsLast Modified:
I have a production/stock/invoicing system written in Access 2007 using sqlserver 2005 as a back end.

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.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros