Zero instead of $0.00???

  • Thread starter Thread starter DBarker
  • Start date Start date
D

DBarker

Actually I figured it out, I had the order of the data
different in both queries when I made it the same it
pulled the data that I was looking for. Now my issue is
within the SQL I want to format it so that it will show 0
values as $0.00 instead of coming back as blank.

Also, I want all credit amounts to show as ($2,000.00)
and not -$2,000.00.
 
Nz() will format null(which you called blank) values.

e.g. Nz([Field], format(0, "Currency")

I don't know how to get it to format negatives with the parens.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Currency format, I believe, puts parentheses around negative numbers by
default.

--
Ken Snell
<MS ACCESS MVP>

[MVP] S.Clark said:
Nz() will format null(which you called blank) values.

e.g. Nz([Field], format(0, "Currency")

I don't know how to get it to format negatives with the parens.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

DBarker said:
Actually I figured it out, I had the order of the data
different in both queries when I made it the same it
pulled the data that I was looking for. Now my issue is
within the SQL I want to format it so that it will show 0
values as $0.00 instead of coming back as blank.

Also, I want all credit amounts to show as ($2,000.00)
and not -$2,000.00.
Click to expand...
Click to expand...
 
Back
Top