I have a calculated field in a report that states: =Sum([Product Need])
How can I have it round up to the nearest 50. In Excel I use (ceiling(cel;50)). How would that be in Access? I tried =ceiling(Sum([Product Need]);50) but that doesn't work.
You would creating a function that would do the same thing as ceiling in Excel.
But since you only need it to round to the closes 50 cents, then you would simply leave out the Significance options out the function.
for Example:

Public Function Ceiling(RoundValue As Currency) As Currency

Dim TheValue As Currency

TheValue = RoundValue

Select Case TheValue  Int(TheValue)

Case Is <= 0.25

Ceiling = Int(TheValue)

Case Is >= 0.5

Ceiling = Int(TheValue) + 1

Case Is >= 0.26

Ceiling = Int(TheValue) + 0.5

End Select

End Function


Then you would copy and paste this into a new module that will hold this public function that you can use anywhere in your application.
If you need any more help, let me know,
Hope that helps,
Joe P.