field formatting issue

[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

 

[John W. Vinson]

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

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 also http://www.utteraccess.com

 

[fishqqq]

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

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

this worked great ! thanks John