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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 05:10 AM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06: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 |