abenitez77
Registered User.
- Local time
- Today, 15:31
- Joined
- Apr 29, 2010
- Messages
- 141
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
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