Dcount is null

Follow Post Reply. ADezii 8, Expert 8TB. Hi ADezii, appreciate the quick response on this. I was trying the wild card with the asterisk but i was doing it backward and using it at the end of the expression. Works great now really appreciate the help!

Also I like the new picture for you avatar :D Take care. Post Reply. Dcount function, return dates in last year in criteria.

DCount function. Syntax in DCount function. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 4 years, 2 months ago. Active 1 year, 6 months ago. Viewed times. Print ReturnedCount. Improve this question.

Erik A Add a comment. Active Oldest Votes. Improve this answer. That gives me a compile error - expected expression error — IcyPopTarts. I was missing a double quote. Welcome to our community! I am trying to check for fields that have missing foreign keys in my ExpensItems table. Each of the attempts below returns Error in the textbox control on my form. Join our community to see this answer!

Unlock 3 Answers and 7 Comments. Andrew Hancock - VMware vExpert. See if this solution works for you by signing up for a 7 day free trial. What do I get with a subscription? With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros.