A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

add yes/no's in access database



 
 
Thread Tools Display Modes
  #1  
Old February 22nd, 2006, 08:31 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default add yes/no's in access database

I created a database that use's the check box(yes/no) my question is "How can
I
tabulte the yes and no's. example: show if 5 or more meetings were attended,
for use in a query
thanks
  #2  
Old February 22nd, 2006, 09:18 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default add yes/no's in access database

I am a bit skeptical about your table structure. However, you can count the
number of Yes values in a Yes/No field using an expression like:
=Abs(Sum([YesNoField]))

--
Duane Hookom
MS Access MVP
--

"robo1a" wrote in message
...
I created a database that use's the check box(yes/no) my question is "How
can
I
tabulte the yes and no's. example: show if 5 or more meetings were
attended,
for use in a query
thanks



  #3  
Old February 22nd, 2006, 10:23 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default add yes/no's in access database

Duane,
Thanks. I'll figure it out now. This is the first database I attempted do
create..LOL
feeling my way through it .ok so far.
Thanks again

"Duane Hookom" wrote:

I am a bit skeptical about your table structure. However, you can count the
number of Yes values in a Yes/No field using an expression like:
=Abs(Sum([YesNoField]))

--
Duane Hookom
MS Access MVP
--

"robo1a" wrote in message
...
I created a database that use's the check box(yes/no) my question is "How
can
I
tabulte the yes and no's. example: show if 5 or more meetings were
attended,
for use in a query
thanks




  #4  
Old February 22nd, 2006, 10:43 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default add yes/no's in access database

hey there - I'll give you a real simply approach....

a. make a new query in Design view and just add the Name Field and the
yes/no field

b. select the greek sum icon from the tool bar (looks like greek E)

this adds a "Total" row to your query builder
'GroupBy' is the default entry - leave this as-is for the Name field

c. in the yes/no field click into right side of 'Groupby' and a drop-down
will appear - - go ahead and change that to 'Count'

then hit the red ! ......and the result will be the name of all and their
count of Yes

easy to scan down it to see whom is above your minimum criteria......hope
this approach helps....
--
NTC


"robo1a" wrote:

I created a database that use's the check box(yes/no) my question is "How can
I
tabulte the yes and no's. example: show if 5 or more meetings were attended,
for use in a query
thanks

  #5  
Old February 23rd, 2006, 04:52 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default add yes/no's in access database



"Duane Hookom" wrote:

I am a bit skeptical about your table structure. However, you can count the
number of Yes values in a Yes/No field using an expression like:
=Abs(Sum([YesNoField]))

--
Duane Hookom
MS Access MVP
--

"robo1a" wrote in message
...
I created a database that use's the check box(yes/no) my question is "How
can
I
tabulte the yes and no's. example: show if 5 or more meetings were
attended,
for use in a query
thanks




  #6  
Old February 23rd, 2006, 05:02 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default add yes/no's in access database

can't seem to get it to function the way I want it to.here's what I have,
name followed by 9 months with yes/no box. I want to add the total months
someone was present at a meeting.
Thanks

"NetworkTrade" wrote:

hey there - I'll give you a real simply approach....

a. make a new query in Design view and just add the Name Field and the
yes/no field

b. select the greek sum icon from the tool bar (looks like greek E)

this adds a "Total" row to your query builder
'GroupBy' is the default entry - leave this as-is for the Name field

c. in the yes/no field click into right side of 'Groupby' and a drop-down
will appear - - go ahead and change that to 'Count'

then hit the red ! ......and the result will be the name of all and their
count of Yes

easy to scan down it to see whom is above your minimum criteria......hope
this approach helps....
--
NTC


"robo1a" wrote:

I created a database that use's the check box(yes/no) my question is "How can
I
tabulte the yes and no's. example: show if 5 or more meetings were attended,
for use in a query
thanks

  #7  
Old February 23rd, 2006, 07:06 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default add yes/no's in access database

Looks like you are "committing spreadsheet". A normalized table would create
one record per meeting attended so you could use a simple SUM or COUNT in a
totals query.

If you can't change your table structure, you can use something like:
Attended: Abs(Nz([Jan],0))+Abs(Nz([Feb],0)) + etc for each month field

--
Duane Hookom
MS Access MVP
--

"robo1a" wrote in message
...
can't seem to get it to function the way I want it to.here's what I have,
name followed by 9 months with yes/no box. I want to add the total months
someone was present at a meeting.
Thanks

"NetworkTrade" wrote:

hey there - I'll give you a real simply approach....

a. make a new query in Design view and just add the Name Field and the
yes/no field

b. select the greek sum icon from the tool bar (looks like greek E)

this adds a "Total" row to your query builder
'GroupBy' is the default entry - leave this as-is for the Name field

c. in the yes/no field click into right side of 'Groupby' and a drop-down
will appear - - go ahead and change that to 'Count'

then hit the red ! ......and the result will be the name of all and
their
count of Yes

easy to scan down it to see whom is above your minimum criteria......hope
this approach helps....
--
NTC


"robo1a" wrote:

I created a database that use's the check box(yes/no) my question is
"How can
I
tabulte the yes and no's. example: show if 5 or more meetings were
attended,
for use in a query
thanks



  #8  
Old February 23rd, 2006, 01:55 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default add yes/no's in access database

Since these are all yes/no fields wouldn't
Attended: Abs([Jan]+[Feb]+[Mar]+...)
work just as well

"Duane Hookom" wrote in message
...
Looks like you are "committing spreadsheet". A normalized table would
create one record per meeting attended so you could use a simple SUM or
COUNT in a totals query.

If you can't change your table structure, you can use something like:
Attended: Abs(Nz([Jan],0))+Abs(Nz([Feb],0)) + etc for each month field

--
Duane Hookom
MS Access MVP
--

"robo1a" wrote in message
...
can't seem to get it to function the way I want it to.here's what I have,
name followed by 9 months with yes/no box. I want to add the total months
someone was present at a meeting.
Thanks

"NetworkTrade" wrote:

hey there - I'll give you a real simply approach....

a. make a new query in Design view and just add the Name Field and the
yes/no field

b. select the greek sum icon from the tool bar (looks like greek E)

this adds a "Total" row to your query builder
'GroupBy' is the default entry - leave this as-is for the Name field

c. in the yes/no field click into right side of 'Groupby' and a
drop-down
will appear - - go ahead and change that to 'Count'

then hit the red ! ......and the result will be the name of all and
their
count of Yes

easy to scan down it to see whom is above your minimum
criteria......hope
this approach helps....
--
NTC


"robo1a" wrote:

I created a database that use's the check box(yes/no) my question is
"How can
I
tabulte the yes and no's. example: show if 5 or more meetings were
attended,
for use in a query
thanks





  #9  
Old February 23rd, 2006, 01:58 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default add yes/no's in access database

Pardon me, but your simple approach won't work on yes/no (boolean) fields.
This field type always has a value - either true or false. Since Count
counts the number of times ANY value exists in a field, the count would the
same as the number of rows in the group.

To count true, you can use a formula
Abs(Sum([YesNoField]))


"NetworkTrade" wrote in message
...
hey there - I'll give you a real simply approach....

a. make a new query in Design view and just add the Name Field and the
yes/no field

b. select the greek sum icon from the tool bar (looks like greek E)

this adds a "Total" row to your query builder
'GroupBy' is the default entry - leave this as-is for the Name field

c. in the yes/no field click into right side of 'Groupby' and a drop-down
will appear - - go ahead and change that to 'Count'

then hit the red ! ......and the result will be the name of all and
their
count of Yes

easy to scan down it to see whom is above your minimum criteria......hope
this approach helps....
--
NTC


"robo1a" wrote:

I created a database that use's the check box(yes/no) my question is "How
can
I
tabulte the yes and no's. example: show if 5 or more meetings were
attended,
for use in a query
thanks



  #10  
Old February 23rd, 2006, 03:51 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default add yes/no's in access database

Greetings John,
I tried the formula you posted and recieved this pop up msg..calculation is
to complex.try using variable...I'm just an old dog trying to learn a new
trick, this is the first database I attempted to build. to say that I am
confused is putting it mildly..Here is what I want it to do for me.
I have a base of 85 members and we have 9 meetings a year.jan thru may. I
would like to see who(last name) attended how many meetings. they need to
attend at least 5 mtg to be eligble for a scholarship fund drawing.I would
like to see ie:
Blow,Joe 7. is this possible.
Thanks for any assistance you can give. Is there a book on this subject that
would help me?
thanks again
Rob M

"John Spencer" wrote:

Pardon me, but your simple approach won't work on yes/no (boolean) fields.
This field type always has a value - either true or false. Since Count
counts the number of times ANY value exists in a field, the count would the
same as the number of rows in the group.

To count true, you can use a formula
Abs(Sum([YesNoField]))


"NetworkTrade" wrote in message
...
hey there - I'll give you a real simply approach....

a. make a new query in Design view and just add the Name Field and the
yes/no field

b. select the greek sum icon from the tool bar (looks like greek E)

this adds a "Total" row to your query builder
'GroupBy' is the default entry - leave this as-is for the Name field

c. in the yes/no field click into right side of 'Groupby' and a drop-down
will appear - - go ahead and change that to 'Count'

then hit the red ! ......and the result will be the name of all and
their
count of Yes

easy to scan down it to see whom is above your minimum criteria......hope
this approach helps....
--
NTC


"robo1a" wrote:

I created a database that use's the check box(yes/no) my question is "How
can
I
tabulte the yes and no's. example: show if 5 or more meetings were
attended,
for use in a query
thanks




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the difference between 2002 and 2003? Red Sonya General Discussion 2 March 1st, 2005 06:10 AM
Access 2000 -vs- Access 2003? Mark General Discussion 5 November 30th, 2004 07:36 AM
Images in a database Franz General Discussion 10 October 7th, 2004 09:35 AM
Access XP Compared to Access 2003 Mardene Leahu New Users 1 October 1st, 2004 05:11 AM
Database Window Gone DaveB General Discussion 2 July 29th, 2004 12:24 AM


All times are GMT +1. The time now is 11:11 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.