PC Review


Reply
Thread Tools Rate Thread

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
your help
 
Reply With Quote
 
 
 
 
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
> your help



 
Reply With Quote
 
 
 
 
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
> your help



 
Reply With Quote
 
=?Utf-8?B?SmFzb24=?=
Guest
Posts: n/a
 
      2nd Nov 2006
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

 
Reply With Quote
 
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
>
> 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



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:16 PM.