Rounding Help

[boostbyslinky]

Morning folks..

Having a little fun with rounding at the moment... I've made some progress but am running into an issue, purely due to the way that I want the rounding to work..

I have times output in decimal style (due to the originating data source) and need to retain the decimal style..
I need to round up to the nearest (or next, I guess) 0.25 value.. And there's the rub, I ALWAYS want to round up..

The expression I have so far is :

Fix Time: Round(4*(Sum([dbo_ReportData].[Fix Time])),0)/4

Which does do rounding nicely, however, it will round down as well as up (which is correct from a mathematical stand point).. As I said previously, I only want to round up! (well, I don't want to, the people that want this report do!)

Happy to post up the rest of the query if you need it..
Any help gratefully received!

 

[boostbyslinky]

Perhaps I should have searched first!

http://www.access-programmers.co.uk/forums/showthread.php?t=218030&highlight=rounding

Issue fixed... New expression is :

Fix Time: -Int(-(Sum([dbo_ReportData].[Fix Time])/0.25))*0.25

Thanks for being here access-programmers.co.uk!