Counting

[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

 

[Jean-Guy Marcil]

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?????????

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