I want to use DCount() with three criteria, but I am getting an error of
Run-time error '13':
Type mismatch
This is the code I have
What is the proper way to use dlookup() with multiple criteria in vba?Code:Public Sub Testing() intNumber = DCount([Shirt Size], "ABCDEFG", "[Final]=0206 AND [Shirt Color] = Red And [Gender]=Boy") End Sub