I need some quick advice please on how to control only 2 characters after the decimal in a table field. I have "Price" set with Decimal 2 and as Currency. But whenever someone types in $1.395 or messes up on the price Access just rounds it up and displays it as $1.40 to us the user and that is fine but when I export it to a CSV file it exports $1.395 and then the website imports it as $1,395.00
So how can I correct this issue and only allow the user to put in 2 characters after the decimal?
Unfortunately none is willing to buy a $1.39 screw for $1,395.00 or I would be filthy rich :)
Also as a side note some of the values in the "Price"field is really weird. Like for a $10.46 item it says "10.4625"???? I know noone messed up that badly. I hope! Any thoughts???
Thanks for the help!