Counting

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

I created option groups with usually 1=yes and 2=no for
answers. In my Report I created calculations that said if
ans is 1 give me yes and 2 give me no. That works OK.

Now I want to count the records with a yes answer in each
column. So I created the following formula for each
column;

=count([field]="1") But I am getting the opposite
answer. I am getting the answer for no's. What am I
doing wrong?????????

Aurora
 
Aurora said:
I am using Access 2000

I created option groups with usually 1=yes and 2=no for
answers. In my Report I created calculations that said if
ans is 1 give me yes and 2 give me no. That works OK.

Now I want to count the records with a yes answer in each
column. So I created the following formula for each
column;

=count([field]="1") But I am getting the opposite
answer. I am getting the answer for no's. What am I
doing wrong?????????
Click to expand...

Posting an Access problem in a Word newsgroup? ;-)
 
Back
Top