Simple Question I think

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to count records in a query. The ield is a yes/no fied and I want
to count the number that are no. I just can't seem to find it. Thank you for
your help
 
Jason

One way to do this would be to use a totals query, in which you count one of
the fields from the table, where the yes/no field = no.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I should search the board before I post. Solution is below. Thank you

Sum(Abs([ASA Admin]))
 
That expression would count the "yes" values and I believe you wanted to
"count the number that are no". I assume you figured this out.

--
Duane Hookom
MS Access MVP

Jason said:
I should search the board before I post. Solution is below. Thank you

Sum(Abs([ASA Admin]))

Jason said:
I am trying to count records in a query. The ield is a yes/no fied and I
want
to count the number that are no. I just can't seem to find it. Thank you
for
your help
Click to expand...
Click to expand...
 
Back
Top