Count in query

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
A

Alex Martinez

Hello,

I am using Access 2002 and I have a query that I want to count what is
populated in the fields. I use the total button on the query design bar and
I get the desire total count in my text fields, but in my Yes/No fields I
get the total row count of my database. I want the total count to count
only what was consider "Yes" in the Yes/No field. All I want is to have an
accurate total count on the text boxes and the Yes/No fields. Any help will
be appreicated. Thank you in advance.
 
Hi,

I thought my problem was unique, but going over the newsgroup I was able to
succussfully use John Spencer (MVP) reply to NoviceIan on June 22, 2005. So
I thank anybody who took the time in reading my problem, which I already
resolved.
 
Hello,

I am using Access 2002 and I have a query that I want to count what is
populated in the fields. I use the total button on the query design bar and
I get the desire total count in my text fields, but in my Yes/No fields I
get the total row count of my database. I want the total count to count
only what was consider "Yes" in the Yes/No field. All I want is to have an
accurate total count on the text boxes and the Yes/No fields. Any help will
be appreicated. Thank you in advance.
Click to expand...

To count Yes results:

CountYes:Abs(Sum([CheckBoxName]))

Change the Group By to Expression in this column.
 
Back
Top