I am trying to use a DSUM function in a form that I've got working with a few critieria. But I want to add one more criteria (with an 'And' function) for a field that usually contains a price (Currency) but may contain nothing (null). I want the DSUM to exclude the Null.
My function that returns the correct result looks like this
=DSum("[d Ext$ BidNeg-PA]","qry RFQ Main","[Account]=[AS] And [RFQYear]=[YS]")
When I add the last criteria to exclude the null I'm getting either the same result as above or an error.
=DSum("[d Ext$ BidNeg-PA]","qry RFQ Main","[Account]=[AS] And [RFQYear]=[YS] And [WW Price] <>null")
Any ideas?
My function that returns the correct result looks like this
=DSum("[d Ext$ BidNeg-PA]","qry RFQ Main","[Account]=[AS] And [RFQYear]=[YS]")
When I add the last criteria to exclude the null I'm getting either the same result as above or an error.
=DSum("[d Ext$ BidNeg-PA]","qry RFQ Main","[Account]=[AS] And [RFQYear]=[YS] And [WW Price] <>null")
Any ideas?