Thread: convert currency to string
View Single Post
  #2  
Old June 2nd, 2010, 08:08 AM posted to microsoft.public.access.queries
Wolfgang Kais[_4_]
external usenet poster
  
Posts: 18
Default convert currency to string
Hello.

"shank"
AMOUNT: CStr([Amazon POs]![Cost]*[Amazon POs]![QtyConfirmed])

How do I convert $45.50 to "45.50" ...?
No matter what I do I keep dropping the zero to "45.5"

AMOUNT: Format([Amazon POs]![Cost]*[Amazon POs]![QtyConfirmed],"0.00")

--
Regards,
Wolfgang