Is Null Criteria in a DSum Expression
Is Null Criteria in a DSum Expression
(OP)
I want to be able to sum all of my outstanding invoices within a form I've created for the specific customer record that is active. My expression is:
=DSum("[Amount]","[Invoices]","[CompanyID]=[txtCompanyID] AND [InvoiceDate]='is null'")
But this just produces an error message. How do I get it to sum the amounts of invoices where the invoice date is blank because I haven't received payment yet? Thanks in advance for your help!!!
=DSum("[Amount]","[Invoices]","[CompanyID]=[txtCompanyID] AND [InvoiceDate]='is null'")
But this just produces an error message. How do I get it to sum the amounts of invoices where the invoice date is blank because I haven't received payment yet? Thanks in advance for your help!!!
RE: Is Null Criteria in a DSum Expression
=DSum("[Amount]","[Invoices]","[CompanyID]='" & [txtCompanyID] & "' AND [InvoiceDate] Is Null")
assuming [txtCompanyID] is, in fact, a text field & not a literal
if it's a form control then replace [txtCompanyID] with Me.txtCompanyID
RE: Is Null Criteria in a DSum Expression
Is Null([Invoice Date])
Mike Rohde
rohdem@marshallengines.com
RE: Is Null Criteria in a DSum Expression
RE: Is Null Criteria in a DSum Expression
Mike Rohde
rohdem@marshallengines.com