View Single Post
Old 11-05-2019, 03:24 PM   #1
abenitez77
Newly Registered User
 
Join Date: Apr 2010
Posts: 127
Thanks: 5
Thanked 0 Times in 0 Posts
abenitez77 is on a distinguished road
Question formatting numbers

I have a report that is using a query where I have a column being formatted in the query like this:
CreditMemoAmt: "- " & CStr(Abs([CreditMemoAmount]))

In the report, numbers like 1,500.00 are coming across like 1500. And 1623,60 are 1623.6

How can i fix this? I want the numbers to appear like this:
-$1,500.00 or ($1,500.00)
- $1,623.60 or ($1,623.60)

thanks,
Alex

abenitez77 is offline   Reply With Quote