# Simple Question I think

=?Utf-8?B?SmFzb24=?=
Guest
Posts: n/a

 2nd Nov 2006
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

Jeff Boyce
Guest
Posts: n/a

 2nd Nov 2006
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

"Jason" <(E-Mail Removed)> wrote in message
news:6DDFBAE8-8FE1-4FB0-A34C-(E-Mail Removed)...
>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

Duane Hookom
Guest
Posts: n/a

 2nd Nov 2006
Use:
Sum([UnNamedYNField]+1)

--
Duane Hookom
MS Access MVP

"Jason" <(E-Mail Removed)> wrote in message
news:6DDFBAE8-8FE1-4FB0-A34C-(E-Mail Removed)...
>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

=?Utf-8?B?SmFzb24=?=
Guest
Posts: n/a

 2nd Nov 2006
I should search the board before I post. Solution is below. Thank you

"Jason" wrote:

> 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

Duane Hookom
Guest
Posts: n/a

 2nd Nov 2006
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" <(E-Mail Removed)> wrote in message
news:846FF3C8-EE80-40A3-98B4-(E-Mail Removed)...
>I should search the board before I post. Solution is below. Thank you
>
>
> "Jason" wrote:
>
>> 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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post raylopez99 Microsoft Windows 2000 Networking 3 11th Feb 2007 02:31 PM =?Utf-8?B?emhvdXh1ZW5haQ==?= Windows XP General 4 9th Nov 2006 02:27 PM =?Utf-8?B?TGVl?= Windows XP New Users 7 4th Aug 2005 03:14 AM clive@bluebottle.com Microsoft Dot NET Framework 1 8th Jul 2005 05:52 PM craigwojo Microsoft Excel New Users 3 29th Aug 2004 05:32 AM

Features