Quick DCount criteria

Sgt Bilkp

Registered User.
Local time
Today, 07:08
Joined
Jan 11, 2008
Messages
66
Had this on one of my forms:

Code:
=DCount("[Serial]","tblMainData","AreaID = 1 AND StateID = 1  AND TypeID = 1")
I also need it to count TypeID = 2

So i have 10 records of Type ID = 1 and 5 of TypeID = 2, my total should come to 15.
 
Maybe something like

Code:
=DCount("[Serial]","tblMainData","AreaID = 1 AND StateID = 1  AND (TypeID = 1 OR TypeID =2)")
 

Users who are viewing this thread

Back
Top Bottom