add yes/no's in access database
Because:
1) I was concerned about possible null values
2) I wanted to apply a keystroke tax for creating an un-normalized table
structure ;-)
--
Duane Hookom
MS Access MVP
--
"John Spencer" wrote in message
...
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
|