View Single Post
  #2  
Old February 22nd, 2006, 08: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