Calculated field

  • Thread starter Thread starter D
  • Start date Start date
D

D

In my query I have a couple of calculated fields which
work fine but they display several decimal places. How can
I limit it to just 4? One calculated field is: B: IIf
(IsNull([FW]),"",Sqr((([FWHM]/57.3)^2)-(0.00356)^2))
Thanks for the help.
 
Thanks, but I really don't know SQL so where would I add
the ROUND function in the example I sent.
-----Original Message-----
Hi,

You can use ROUND function ...

D said:
In my query I have a couple of calculated fields which
work fine but they display several decimal places. How can
I limit it to just 4? One calculated field is: B: IIf
(IsNull([FW]),"",Sqr((([FWHM]/57.3)^2)-(0.00356)^2))
Thanks for the help.
Click to expand...


.
Click to expand...
 
Have you tried setting the Format of the Field to "0.0000"?

HTH
Van T. Dinh
MVP (Access)
 
It didn't have any effect.
-----Original Message-----
Have you tried setting the Format of the Field to "0.0000"?

HTH
Van T. Dinh
MVP (Access)



-----Original Message-----
In my query I have a couple of calculated fields which
work fine but they display several decimal places. How can
I limit it to just 4? One calculated field is: B: IIf
(IsNull([FW]),"",Sqr((([FWHM]/57.3)^2)-(0.00356)^2))
Thanks for the help.
.
Click to expand...
.
Click to expand...
 
Maybe this is what you meant all along but I was trying
Field properties. Finally changed the expression to:
B: Format(IIf(IsNull([FWHM]),"",Sqr((([FWHM]/57.3)^2)-
(0.00356)^2)),"#.0000")and it works!
-----Original Message-----
It didn't have any effect.
-----Original Message-----
Have you tried setting the Format of the Field to "0.0000"?

HTH
Van T. Dinh
MVP (Access)



-----Original Message-----
In my query I have a couple of calculated fields which
work fine but they display several decimal places. How can
I limit it to just 4? One calculated field is: B: IIf
(IsNull([FW]),"",Sqr((([FWHM]/57.3)^2)-(0.00356)^2))
Thanks for the help.
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top