Roundup in a Query

[jpro]

I need to run a query that will show a calculation of pallet requirements that needs to be rounded up regardless of the decimal value - (Ex. 1.2 needs to = 2 pallets). My result is calculated by the division of 2 table values:
Pallet req: [total req]/[unit count]

Is there a criteria or something (aside from any VB which I do not have knowledge of) that can accomplish this?


THX

 

[GoDawgs]

Not sure if there's an easier way or not, but this is the first thing that came to mind:

Pallet req: iif([total req]/[unit count])-INT([total req]/[unit count])>0, INT([total req]/[unit count])+1, ([total req]/[unit count]))

Kind of round about, but I think that should work, hope that helps.

Kevin

 

[danvlas]

PalletReq: Int([total req]/[unit count])+Sgn([total req]/[unit count]-Int([total req]/[unit count])

should do the trick.

Regards,
Dan

 

[jpro]

Thank you very much, It worked Great!!!!!!!!