Had this on one of my forms:
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.
Code:
=DCount("[Serial]","tblMainData","AreaID = 1 AND StateID = 1 AND TypeID = 1")
So i have 10 records of Type ID = 1 and 5 of TypeID = 2, my total should come to 15.