trim decimals

[Guest]

i have a calculated field in query like this
amount=[fcamount]*[roe]
is property set to standard and 3 decimals.but actully it is not saving only
3 deci , but saving it full.
how can i save only 3 decimals ( not just show 3 deci and store it full)

 

[Guest]

Amount: Int(([fcamount]*[roe]) * 1000)/1000

 

[Guest]

Try using the Round function

amount=Round([fcamount]*[roe] ,3)

 

[Guest]

A much nicer solution than mine.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Try using the Round function

amount=Round([fcamount]*[roe] ,3)


--
Good Luck
BS"D

i have a calculated field in query like this
amount=[fcamount]*[roe]
is property set to standard and 3 decimals.but actully it is not saving only
3 deci , but saving it full.
how can i save only 3 decimals ( not just show 3 deci and store it full)

 

[Guest]

Thanks to both of you for help and reply.