ROUNDING

[jlnewbie]

In Excel I can round to the nearest tenth unsing ROUND(A3,-1).
Example 3426, Rounds to 3430.
I don't seem to find an an Access query function that does not do this? I've tried ROUND([CS],-1) and I get an error.
Thank you



JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service

 

[jlnewbie]

Thank but I found my answer by searching

val(format ([CS]/10,"0"))*10



JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service

 

[PHV]

Why not simply this ?
10*CLng([CS]/10)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MichaelRed]

rounding can be tiresome and difficult, depending on the desired degree of accuracy and conrol. There are a number of threads in htese fora (Tek-Tips) addressing the issue. If you really want to have control over the process and results, use search / advanced search: Keyword(s) [Round]




MichaelRed

 

[ddiamond]

10*Fix(CS/10)

 

[PHV]

ddiamond, the Fix function doesn't rounds but truncates ...

 

[ddiamond]

PHV, that is true. It depends what your goal is. If you really want to round, then your suggestion of clng is what you want.