field formatting issue

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top