UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Can I force a query to return only 2 decimal places?    
 
   
sync00
post Mar 21 2006, 03:41 PM
Post #1

UtterAccess Addict
Posts: 146
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]
Go to the top of the page
 
+
 
 Start new topic
Replies (1 - 1)
sync00
post Mar 21 2006, 03:50 PM
Post #2

UtterAccess Addict
Posts: 146
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
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 08:10 AM