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