convert currency to string

S

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"

thanks!
 
W

Wolfgang Kais

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"
Click to expand...

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

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

Similar Threads

Mail merge to word 1
Code Check Request - Query to find reused values 2
calculating a remainder field 0
Convert PDF to Visio File or Editable PDF in Visio 0
How to remove a bracket that is itallicised for an entire document 1
To make pdf to work as word 1
Expressions in queries that have an #error message come up in rec 1
Converting numeric state postal code to 2 digit text 1

Top