Simple code syntax question

[mseeker22]

I'm trying to get this statement to return a 0 (Zero) if Null . . . for some reason I can't get it right.

=DSum("[Discount Value]","Q_SCUsage")

Something like

IIF(IsNull(=DSum("[Discount Value]","Q_SCUsage")),"0",(=DSum("[Discount Value]","Q_SCUsage")))

Getting my syntax muddled up I think . . . its the DSum thats throwing me a little!

Thanks

[mseeker22]

Got it working . . . using Nz function -

=Nz(DSum("[Discount Value]","Q_SCUsage"),0)

Just in case anyone is looking in the future