Roundup Function

  • Thread starter Thread starter aMack
  • Start date Start date
A

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
 
Thanks - That did it.


--
A MACKENZIE, CMA, MBA


Allen Browne said:
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.

aMack said:
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
Click to expand...
Click to expand...
 
Back
Top