Full Version: Can I force a query to return only 2 decimal places?
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
sync00
Mar 21 2006, 03:41 PM
The following Select is returning 10 decimal places. How can I get it to return only 2 decimal places?

CODE
IIf([Inventory]![NumPerCase]>0,
   Round([UNFI Pricelist]![CSRP]/[Inventory]![NumPerCase],2),
   Round([UNFI Pricelist]![CSRP],2))
   AS [New Price]
sync00
Mar 21 2006, 03:50 PM
I initially thought I was getting so many decimal places from the division, but it's actually coming from the false part of the IIF. For some reason I don't understand, 2.49 becomes 2.49000000953674
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.