Dcount Dilema

[JOM]

I am trying to count requests for each employee that have been completed in a
a given day e.g., on

07/15 I rcvd 3 requests, 2 were completed on 7/15 and 1 is still pending but
is completed 7/16
07/16 I rcvd 4 requests, 1 was completed on 7/16 and 4 are pending

So my report kinda looks like this

Date rcvd Completed pending
07/15 3 2 1
07/16 4 1 4

My current Dcount statement is as follows
=DCount("[RqstCompleted]","qryRqst","[EmpID]= " & [EmpID] & "and [Date]= " &
[Date] & "and[DateCompleted]=[date]" & "and[RequestCompleted]=true")

I think am doing something wrong