DCount Mystery

[George R]

The following data source in an unbound text box in a report footer produces
"0" on my PC but "Err" on the client's PC when the underlying query has no
records. Both PCs use Access 07:
=DCount("ClientID","qryGradsCurYr-1")
The underlying query is:
SELECT tblClients.ClientID, tblActivities.EventNum, tblActivities.DateOfAct
FROM tblClients INNER JOIN tblActivities ON tblClients.ClientID =
tblActivities.ClientID
WHERE (((tblActivities.EventNum)=4) AND ((tblActivities.DateOfAct) Between
([Forms]![frmDateParameters].[BeginDate]-365) And
([Forms]![frmDateParameters].[EndDate]-365)));
I will try =Nz(DCount("ClientID","qryGradsCurYr-1")) when I get back to the
client's PC, but what could make this difference between the two PCs?
Thank you for your consideration.

 

[Evi]

Bet it's his References (open a module, go to Tools, References. Compare the
References on your machine to his.
Evi

 

[George R]

Thanks Evi,
I will give that a try