field formatting issue

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

fishqqq

I have a field that i've formatted as follows :

="$" & [total costs] & " " & [Text39]

this returns the following: $4.63680016994476 CDN

can someone suggest how i could format this so it will return : $4.64
CDN (instead of all the decimal places)?

thanks
Steve
 
can someone suggest how i could format this so it will return : $4.64
CDN (instead of all the decimal places)?
Click to expand...

Format([Total Costs], "Currency") & " CDN"

or

Format([Total Costs], "\$#.00 CDN")
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com
Click to expand...

this worked great ! thanks John
 
Back
Top