G
Guest
I tried using DCount in a report referencing a query that had three linked
tables and some criteria filtering. The query shows results fine. When I
switched references to a table it worked fine, so I know my syntax is
correct. My thought is that it doesn't like the query. Are there some queries
you can't use domain functions on? For instance, this query has the Unique
Values property set to Yes. There is also a calculated field name that uses a
function of the same name (not referenced in the DCount). Is that a no-no?
Here is my syntax-pretty basic:
=DCount("StudentID","qryCountbyDONStudentsUnique")
tables and some criteria filtering. The query shows results fine. When I
switched references to a table it worked fine, so I know my syntax is
correct. My thought is that it doesn't like the query. Are there some queries
you can't use domain functions on? For instance, this query has the Unique
Values property set to Yes. There is also a calculated field name that uses a
function of the same name (not referenced in the DCount). Is that a no-no?
Here is my syntax-pretty basic:
=DCount("StudentID","qryCountbyDONStudentsUnique")