Simple Question I think

's Computer Specifications

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

's Computer Specifications

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
> your help

's Computer Specifications

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
> your help

's Computer Specifications

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

Sum(Abs([ASA Admin]))

"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
> your help

's Computer Specifications

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
>
> Sum(Abs([ASA Admin]))
>
> "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
>> your help

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Simple questions for simple 2 PC file sharing network. Simple?	raylopez99	Microsoft Windows 2000 Networking	3	11th Feb 2007 02:31 PM
I think this is a backdoor to PC. What do you think?	=?Utf-8?B?emhvdXh1ZW5haQ==?=	Windows XP General	4	9th Nov 2006 02:27 PM
i think i have a video card error... I think?	=?Utf-8?B?TGVl?=	Windows XP New Users	7	4th Aug 2005 03:14 AM
ComboBox: I think an exception should be thrown, but the designers don't think so	clive@bluebottle.com	Microsoft Dot NET Framework	1	8th Jul 2005 05:52 PM
Simple Simple Simple	craigwojo	Microsoft Excel New Users	3	29th Aug 2004 05:32 AM