Use Count with multiple criteria

[trident]

I have created a split form, where all the details are found on the bottom.



The details are as follows:

Database - emaildb
Status - 33-Active, 34-Inactive
CustomerSupplier - 1-Customer, 2-Supplier
Unique Number - ID

I have made a text box with the following details:

=Count(IIf([emailstat]=33,0) And IIf([suppliercustomer]=1,0))

This works like a charm but it counts the whole list, and not the active/customer only.

If I put ID after count as below:

=Count([ID],IIf([emailstat]=33,0) And IIf([suppliercustomer]=1,0))

an error appears "THE EXPRESSION YOU ENTERED HAS A FUNCTION CONTAINING THE WRONG NUMBER OF ARGUMENTS".

can you please assists me on this.

thank you.

Trident

[Minty]

Use a Dcount()

DCount("ID","YourTableName","[EmailStat] = 34 AND [SupplierCustomer] = 1")