Counting only true records and not everything

J

JOM

I have a table that has several fields that are yes or no. In my reports, I
would like to count a field that had only yes e.g theI have Consent, Email,
Fax,Onhold
There are several recods that have consent checked email checked and on hold
checked. I have count([Consent]) Count() etc, so it count all the
records and I only want it to count the yess' and not the yes and no...

Please Help!

OJ
 
J

JOM

Thanks you so much that helped alot and it worked, I learnt something there!
Oj!

Dennis said:
Use Dcount instead of Count
=DCount("[Consent]","YourTable","[Consent] = True")

JOM said:
I have a table that has several fields that are yes or no. In my reports, I
would like to count a field that had only yes e.g theI have Consent, Email,
Fax,Onhold
There are several recods that have consent checked email checked and on hold
checked. I have count([Consent]) Count() etc, so it count all the
records and I only want it to count the yess' and not the yes and no...

Please Help!

OJ
[/QUOTE][/QUOTE]
Click to expand...
Click to expand...
 
J

JOM

I have a question, my other report is based on a query which and I wanted to
do the same thing, the thing is that I tried what you said and it worked, it
counts everything in the query but I have another report based on an employee
and I tried the following but it gave me an error
=DCount("[ChangeVOE]","[EmpID]=Query![Individual Follow Up
Query]![EmpID]","[ChangeVOE]=True")
oj!

Dennis said:
Use Dcount instead of Count
=DCount("[Consent]","YourTable","[Consent] = True")

JOM said:
I have a table that has several fields that are yes or no. In my reports, I
would like to count a field that had only yes e.g theI have Consent, Email,
Fax,Onhold
There are several recods that have consent checked email checked and on hold
checked. I have count([Consent]) Count() etc, so it count all the
records and I only want it to count the yess' and not the yes and no...

Please Help!

OJ
[/QUOTE][/QUOTE]
Click to expand...
Click to expand...
 
Top