Hi,
I'm having trouble getting a DCount function to work on an MSAccess 2003 report.
I'm using a text box in a group footer - I want it to show a count of the number of distinct records in the group.
Here's what I'm using - which produces the result of '#Error' with no further help.:
=DCount("Task ID","Tasks","TaskID IN (SELECT DISTINCT TaskID FROM R_TaskID)")
I'm aware of the access definition of expr, domain and criteria syntax for this function, however, I'm not sure what to use for the 'domain' in this scenario.
Expr - I gather this should be the field I want to count - 'Task ID' - the field is part of the report detail.
Domain - here's where I'm sure I've gone wrong. I think this should be the group recordset but I don't know how to reference them The report uses a query containing tables and queries - but it doesn't have a name. How do I reference the report group level
Criteria - hopefully I have this right - I am calling a query.
Thanks in advance for any assistance.
Liz