RoundUp function in Access

[Nick Hampu]

I'm trying to round up a calculation that represents the minimum number of parts my customer needs to buy if there is a $150 minimum order. Say that the field [part price] reflects a cost of $6.50. Taking $150 / [part price] comes out to 23.076. I need to round up the remainder and show 24 in the [minimum order] field.

Thanks in advance

N.H.

 

[Dugantrain]

There's no built in function that I know of to do this sort of Rounding but here's a small function which should get you what you need:

Public Function fRound_Up(numArg As Single) As Long
If numArg = 0 Then
    MsgBox "You Cannot Divide By 0!", vbExclamation
Else
    If 150 / numArg > CInt(150 / numArg) Then
        fRound_Up = CInt(150 / numArg) + 1
    Else
        fRound_Up = 150 / numArg
    End If
End If
End Function

Public Function ftest_it()
MsgBox fRound_Up(6.5)
End Function

 

[bat17]

Not tested! but I think this will do what you are after

= iif(int([minimum order]/ [part price]=[minimum order]/[part price]),[minimum order]/[part price],int([minimum order]/[part price])+1)

HTH

Peter