trim decimals

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
A much nicer solution than mine.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Ofer Cohen said:
Try using the Round function

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


--
Good Luck
BS"D


mhmaid said:
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)
Click to expand...
Click to expand...
 
Back
Top