Count Based on Criteria in Multiple Fields

[Pat Z.]

Field names:
CreatedBy, CommRep,PaymentDate,PaymentAmount,Cust_Nbr

My recordset should count the Cust_Nbr field if CreatedBy OR CommRep =
CPRYBAL (sales rep name).

Here is what is in my field row in my query:

Sum(Abs(IIf([CreatedBy]="CPrybal" Or
[Commission_Rep]="CPrybal",[Cust_Nbr],0)))

I'm getting a datatype mismatch when I try to run the query.

I'm stuck...
Thanks in advance!

 

[Chris]

Try this expression:

Sum(IIf([CreatedBy]="CPrybal" Or
[Commission_Rep]="CPrybal",1,0))

 

[Pat Z.]

That works! Thanks!!!

Try this expression:

Sum(IIf([CreatedBy]="CPrybal" Or
[Commission_Rep]="CPrybal",1,0))

Field names:
CreatedBy, CommRep,PaymentDate,PaymentAmount,Cust_Nbr

My recordset should count the Cust_Nbr field if CreatedBy OR CommRep =
CPRYBAL (sales rep name).

Here is what is in my field row in my query:

Sum(Abs(IIf([CreatedBy]="CPrybal" Or
[Commission_Rep]="CPrybal",[Cust_Nbr],0)))

I'm getting a datatype mismatch when I try to run the query.

I'm stuck...
Thanks in advance!