Query Functions

[Guest]

I am creating a query that multpies to fields and displays the results and
I've noticed in Excel that there is a Round, RoundUp and RoundDown function
but in Access there only seems to be a Round. Is there anyway to have Access
RoundUp or RoundDown?

 

[Guest]

To round down use:
Int([YourNumber])

To round up use:
-Int(-[YourNumber])

 

[Guest]

Awesome! Thanks!

To round down use:
Int([YourNumber])

To round up use:
-Int(-[YourNumber])

--
Good Luck
BS"D

I am creating a query that multpies to fields and displays the results and
I've noticed in Excel that there is a Round, RoundUp and RoundDown function
but in Access there only seems to be a Round. Is there anyway to have Access
RoundUp or RoundDown?