Rounding Question

[Golfinray]

I have a query that calculates numbers. The numbers are like 14.7256589 or
10.2356343. How do you round those to 2 decimal places? I could do a left
function and just cut them off at 2 decimal places but I actually want
rounding. I also tried the round function and I couldn't get that to work
either. Thanks so much!!!

 

[J_Goddard via AccessMonster.com]

Hi -

In the query design view, right-click the field you want to format, then
select Properties on the popup. Set the format to "Fixed" and Decimal Places
to 2.

John

I have a query that calculates numbers. The numbers are like 14.7256589 or
10.2356343. How do you round those to 2 decimal places? I could do a left
function and just cut them off at 2 decimal places but I actually want
rounding. I also tried the round function and I couldn't get that to work
either. Thanks so much!!!

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via AccessMonster.com

 

[Golfinray]

Thanks anyway folks but I found my rounding problem syntax error. Thanks!

 

[DMcclung]

I'm having the same rounding problem and can't figure out the syntax error.
What is the proper way?