Using the count function with a condition in an Access Report

[kash]

Hi,

I have an access report pulling information from a query. One of the fields
is “PHD†and it has values “yesâ€, “No†& “N/Aâ€. I understand that I can use
“=count ([PHD])†in a text box to count the total number of people with PHDs
but is it possible for me to only count the number of people with PHDs (“Yesâ€
value)?

Please help!!!!!!!!!!!!!
KASH

 

[fredg]

Hi,

I have an access report pulling information from a query. One of the fields
is ´PHD¡ and it has values ´yes¡, ´No¡ & ´N/A¡. I understand that I can use
´=count ([PHD])¡ in a text box to count the total number of people with PHDs
but is it possible for me to only count the number of people with PHDs (´Yes¡
value)?

Please help!!!!!!!!!!!!!
KASH

How about an unbound control with a controls source of:

=Sum(IIf([PHD] = "Yes",1,0))

 

[kash]

Thanks a lot!
This works perfectly!

Hi,

I have an access report pulling information from a query. One of the fields
is “PHD†and it has values “yesâ€, “No†& “N/Aâ€. I understand that I can use
“=count ([PHD])†in a text box to count the total number of people with PHDs
but is it possible for me to only count the number of people with PHDs (“Yesâ€
value)?

Please help!!!!!!!!!!!!!
KASH

How about an unbound control with a controls source of:

=Sum(IIf([PHD] = "Yes",1,0))

 

[SL]

Hi
I am trying to do the same thing but my field name is "line No_" and the
value I want to count is 10000. I tried =Sum(IIf([line No_] = "10000",1,0)).
but keep getting errors. I am on the right track?

Thanks
SL

Hi,

I have an access report pulling information from a query. One of the fields
is “PHD†and it has values “yesâ€, “No†& “N/Aâ€. I understand that I can use
“=count ([PHD])†in a text box to count the total number of people with PHDs
but is it possible for me to only count the number of people with PHDs (“Yesâ€
value)?

Please help!!!!!!!!!!!!!
KASH

How about an unbound control with a controls source of:

=Sum(IIf([PHD] = "Yes",1,0))

 

[Douglas J. Steele]

Assuming it's a numeric field, get rid of the quotes around 10000

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi
I am trying to do the same thing but my field name is "line No_" and the
value I want to count is 10000. I tried =Sum(IIf([line No_] =
"10000",1,0)).
but keep getting errors. I am on the right track?

Thanks
SL

Hi,

I have an access report pulling information from a query. One of the
fields
is "PHD" and it has values "yes", "No" & "N/A". I understand that I
can use
"=count ([PHD])" in a text box to count the total number of people with
PHDs
but is it possible for me to only count the number of people with PHDs
("Yes"
value)?

Please help!!!!!!!!!!!!!
KASH

How about an unbound control with a controls source of:

=Sum(IIf([PHD] = "Yes",1,0))

 

[terri]

OMG !!! this is just wonderful !! thank you soooo much...been brain frying
over this type of thing all morning and you posted the answer !! thank you
thank you thank you !!!!
--
terri

Hi,

I have an access report pulling information from a query. One of the fields
is “PHD†and it has values “yesâ€, “No†& “N/Aâ€. I understand that I can use
“=count ([PHD])†in a text box to count the total number of people with PHDs
but is it possible for me to only count the number of people with PHDs (“Yesâ€
value)?

Please help!!!!!!!!!!!!!
KASH

How about an unbound control with a controls source of:

=Sum(IIf([PHD] = "Yes",1,0))

 

[Fee08]

THANK YOU!!!!! - this forum is fantastic as most of the things that I'm
wrestling with are already answered. This is just one of them.
Fee08

 

[Conrad]

Hi,

i really need help to find out the easiest formula to be used to find out
the total value in the report design view. if u really don't mind, i can
upload the documents and you can help me.

Conrad
thanks