[AccessD] A2003: Distinct or Group by in a DLookup

Hi Team

I have a simple DLOOKUP working well

intRecordCount = DCount("[ClientID]", "tblPendingActions")

But I want to know - Is there a "Distinct" version of the same?

 

EG

intRecordCount May return 10 records (but this may only be across say 2
accounts)

So I want to know if there is something where I can group on the ClientID - like

intRecordCount = DCount(Distinct("[ClientID]", "tblPendingActions"))

 

Many thanks in advance

 

Darren