NZ Function -- PLEASE HELP!!

B

bteitelbaum

Hi All,

I have a query, and in this query I am calculating Difference.

So thats what I have:


Difference: ([Quantum Daily Trading]-nz([C1 PnL Attribution Actual],
0))


Everything is working good, but C1 PnL Attribution Actual has a NULL
value. So query spits an empty field, and my manager wants to see 0.

Please resond to: [email protected]


Thanks in advance,
B
 
D

Douglas J. Steele

If C1 PnL Attribution Actual is Null, then the Nz function will replace it
with 0.

Are you sure it's not Quantum Daily Trading that's Null?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Hi All,

I have a query, and in this query I am calculating Difference.

So thats what I have:


Difference: ([Quantum Daily Trading]-nz([C1 PnL Attribution Actual],
0))


Everything is working good, but C1 PnL Attribution Actual has a NULL
value. So query spits an empty field, and my manager wants to see 0.

Please resond to: [email protected]
Click to expand...

That's not how newsgroups work. If you post your question to the newsgroup,
you come back to the newsgroup to get your answer.

And you REALLY shouldn't ever post your actual e-mail in newsgroups: there
are lots of unscrupulous people out there who "scrape" e-mails from
newsgroups and use them for spamming.
 
Top