NZ Function -- PLEASE HELP!!

[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: (e-mail address removed)


Thanks in advance,
B

 

[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: (e-mail address removed)

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.