C Carly Registered User. Local time Today, 19:24 Joined Apr 16, 2003 Messages 86 Sep 16, 2005 #1 I have got a formula in a Query as follows: Suggested Qty: [StockQty]/[Numerator] How do I round this down to the nearest 1? (i.e 7.2 = 7 or 9.9 = 9) Any help would be greatly received. Regards Carly
I have got a formula in a Query as follows: Suggested Qty: [StockQty]/[Numerator] How do I round this down to the nearest 1? (i.e 7.2 = 7 or 9.9 = 9) Any help would be greatly received. Regards Carly
KenHigg Registered User Local time Today, 14:24 Joined Jun 9, 2004 Messages 13,291 Sep 16, 2005 #2 . . . . int([StockQty]/[Numerator])
C Carly Registered User. Local time Today, 19:24 Joined Apr 16, 2003 Messages 86 Sep 16, 2005 #3 Thanks that was a great help!
KenHigg Registered User Local time Today, 14:24 Joined Jun 9, 2004 Messages 13,291 Sep 16, 2005 #4 You're welcome!