Dcount with Multiple Conditions

[Ksabai]

Iam getting error with the following Line:

If DCount("[Duty]", "tblstaff", "[SellerID]= sSellerID And ([Duty] = 8 Or [Duty] = 12)") >= 1 Then
Also tried - If DCount("[Duty]", "tblstaff", "[SellerID]=" & sSellerID And "([Duty] = 8 Or [Duty] = 12)") >= 1 Then
sSellerID is an Integer

Can Someone help

 

[arnelgp]

if SellerID is string:

If DCount("[Duty]", "tblstaff", "[SellerID]= '" & sSellerID & "' And ([Duty] = 8 Or [Duty] = 12)") >= 1

or Numeric:

If DCount("[Duty]", "tblstaff", "[SellerID]= " & sSellerID & " And ([Duty] = 8 Or [Duty] = 12)") >= 1

also you can use Nz() function, in case tblStaff has no record yet, eg:

If Nz(DCount("[Duty]", "tblstaff", "[SellerID]= " & sSellerID & " And ([Duty] = 8 Or [Duty] = 12)"), 0) >= 1

 

[June7]

If there are no records in table, DCount() will return 0 so Nz is not needed.

 

[Bullschmidt]

Yes isn't it interesting that DSum() and DMax() need the Nz() (to convert a Null to 0) but DCount() does not...

 

[June7]

I think DCount() is the only domain aggregate that does not return Null.