Zero instead of $0.00???

[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.

 

[[MVP] S.Clark]

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Ken Snell]

Currency format, I believe, puts parentheses around negative numbers by
default.

--
Ken Snell
<MS ACCESS MVP>

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

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.