Roundup Function

[aMack]

I can get the roundup function to do what I need in Excel - it does not give
the same results in Access.

Excel:
=ROUNDUP(2161/36,0)

Result is 61 in Excel. How can I get this to be 61 in Access.

Access Query Line:
Roundup([Bundles In Qty]/([Cases per Layer]*[Layers per Pallet]),0)

[Bundles In Qty]=Number, Single, ,1 -- Data 2161
[Cases per Layer]=Number, Long, Standard, 0 -- Data 9
[Layers per Pallet]=Number, Long, Standard, 0 -- Data 4

Thanks

 

[Allen Browne]

Access doesn't have a RoundUp(). Try:
- Int(- [Bundles In Qty] / ([Cases per Layer] * [Layers per Pallet]))

Explanation:
http://allenbrowne.com/round.html#RoundUp

 

[aMack]

Thanks - That did it.


--
A MACKENZIE, CMA, MBA

Access doesn't have a RoundUp(). Try:
- Int(- [Bundles In Qty] / ([Cases per Layer] * [Layers per Pallet]))

Explanation:
http://allenbrowne.com/round.html#RoundUp
--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I can get the roundup function to do what I need in Excel - it does not
give
the same results in Access.

Excel:
=ROUNDUP(2161/36,0)

Result is 61 in Excel. How can I get this to be 61 in Access.

Access Query Line:
Roundup([Bundles In Qty]/([Cases per Layer]*[Layers per Pallet]),0)

[Bundles In Qty]=Number, Single, ,1 -- Data 2161
[Cases per Layer]=Number, Long, Standard, 0 -- Data 9
[Layers per Pallet]=Number, Long, Standard, 0 -- Data 4

Thanks