DCount w/ Multiple Criteria

[Ganymede]

There has been a lot written on this subject but I can't seem to find the solution.



Desired result: I am writing a dcount in a form textbox that will count the number of records in which the "Status" column = "Pending Paralegal Filing", the "Appeal Deadline" column reflects today's date, and the "Designated Paralegal" = the same value in a form control. Here is my code.

=DCount("[Status]","CostReportAppealsParalegalWindowQ","[Status]= '" & "Pending Paralegal Filing" & "' And [Appeal Deadline]= #" & Format(Date(),"mm/dd/yyyy") & "#" And "[Designated Paralegal] = '" & [Forms]![Login]![cboUser].[Column](3) & "'")

Based on the result I am getting, I think it is counting the number of times each of those criteria appear in each of those columns and adding the result, as opposed to counting the number of records in which each of those criteria are present. Is there another way to achieve the result I am seeking?

[Welshgasman]

Always put the criteria into a string variable and debug.print it until you get it correct. Then just use that in your function.

Here is my attempt, as I do not have the data to do just that.

=DCount("[Status]","CostReportAppealsParalegalWindowQ","[Status]= 'Pending Paralegal Filing'  And [Appeal Deadline]= #" & Format(Date(),"mm/dd/yyyy") & "# And [Designated Paralegal] = '" & [Forms]![Login]![cboUser].[Column](3) & "'")

[June7]

Or this:

=DCount("*","CostReportAppealsParalegalWindowQ","[Status]= 'Pending Paralegal Filing' And [Appeal Deadline]=Date() And [Designated Paralegal] = '" & [Forms]![Login]![cboUser].Column(3) & "'")

I presume column 3 of combobox has user name but really should be using user ID instead for filter criteria.

[Ganymede]

Thank you, Both! Resolved!