DCount help

[Moxy1]

I am stuck on a DCount issue. I have the following DCount on a report which works great:

=DCount("[Group_Responsible]","tblCallLog","[Date_Entered] Between # " & [Forms].[frmDateRange].[Beginning_Date] & " # AND # " & [Forms].[frmDateRange].[Ending_Date] & " # &quot

This will give me a count on all calls between a date range. However I need add addtional criteria. In addtion to the date range a need to have it pull for a particular Group Responible as follows:

=DCount("[Group_Responsible]","tblCallLog","[Group_Responsible] = 'Group 1'&quot

Question: How do I get this to work in 1 DCount function

Thanks,
Moxy

 

[930driver]

Just string another AND in your sql where clause

=DCount("[Group_Responsible]","tblCallLog","([Date_Entered] Between # " & [Forms].[frmDateRange].[Beginning_Date] & " # AND # " & [Forms].[frmDateRange].[Ending_Date] & " #) AND [Group_Responsible] = 'Group 1'&quot
"The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[Moxy1]

It's always the most obvious isn't it?

Thank you so much for you help