Rounding Question

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

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!!!
 
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!!!
Click to expand...

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

Message posted via AccessMonster.com
 
I'm having the same rounding problem and can't figure out the syntax error.
What is the proper way?
 
Back
Top