rounding in access

C

Cory

I wrote a significant figures rounding function and it
works great in excel but it will not round a number
greater than 1000 to 3 significant figures can anyone help
 
J

John Vinson

I wrote a significant figures rounding function and it
works great in excel but it will not round a number
greater than 1000 to 3 significant figures can anyone help
Click to expand...

Care to post the function? Are you using a Float (which is limited to
about 7 decimal places accuracy) or a Double (which will give you
about 14)? 1034.228 uses all seven places...
 
Top