Rounding Down to Nearest 1

Carly

Registered User.
Local time
Today, 19:24
Joined
Apr 16, 2003
Messages
86
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
 
Thanks that was a great help!
 

Users who are viewing this thread

Back
Top Bottom