decimal places and rounding

[Guest]

I am using qry to find result of two fields (Invoice amount x ROE)=amount in
local currency.but usually the result will be more than 3 decimal places.if i
use the properties to set decimal places to 3, it will only hide the rest of
decimals , but i want it to remove it , and i creat report, i should get
correct amount which is the total of all amounts with only 3 decimal
places.this is the problem i am facing .so is there any thing esle i must set
? or what should i do?

 

[Rick B]

Use the ROUND function....

=ROUND(Invoice amount x ROE,2)

 

[MGFoster]

I am using qry to find result of two fields (Invoice amount x ROE)=amount in
local currency.but usually the result will be more than 3 decimal places.if i
use the properties to set decimal places to 3, it will only hide the rest of
decimals , but i want it to remove it , and i creat report, i should get
correct amount which is the total of all amounts with only 3 decimal
places.this is the problem i am facing .so is there any thing esle i must set
? or what should i do?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use Format() to get the 3 decimal places. Then convert the string
result of the Format() function to a number:

Val(Format(InvoiceAmt * ROE, "#.###"))

The Format() function will round out the number.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ+5F54echKqOuFEgEQLVkgCfa4Hrq8c+aa86EsnnUc6Vfhh62MQAoL+6
rk4eJIxEPZlDrDFYEk8PAUkH
=bQHB
-----END PGP SIGNATURE-----