Trying to count number of records in a payment table where a payment type wasn't entered:
=DCount("[PaymentAmount]","tblPayments","[PaymentType] = IsNull")
gives me #Error.
Please help.
Thanks,
Al
Trying to count number of records in a payment table where a payment type wasn't entered:
=DCount("[PaymentAmount]","tblPayments","[PaymentType] = IsNull")
gives me #Error.
Please help.
Thanks,
Al
=DCount("[PaymentAmount]","tblPayments","isnull([PaymentType])")
THANKS!!
Al