ACCESS FEED: [MS_AccessPros] Re: Logic/SQL/Checkbox issue.. I have 5 chkboxes need to know if more than 1 is chec

I don't think that's a bright idea. I did some research and both poles are at opposites.

But who knows? Watt will be will be.

Bill

--- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@...> wrote:
>
> Don't be so negative! All we need is some bunny to cell the idea.
>
> ;-) Graham
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terence
> Sent: Thursday, 15 September 2011 10:11
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Logic/SQL/Checkbox issue.. I have 5 chkboxes
> need to know if more than 1 is chec
>
>
>
>
>
> Do you think we have the Capacity to continue these CURRENT Puns ?
> terence
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca"
> <wrmosca@> wrote:
> >
> > It's almost terminal! But I try to stay positive.
> >
> > Sparky
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , George
> <george_hepworth@> wrote:
> > >
> > > Writing bad battery puns must be exhausting..
> > >
> > >
> > >
> > > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> > > Sent: Wednesday, September 14, 2011 7:21 AM
> > > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > Subject: [MS_AccessPros] Re: Logic/SQL/Checkbox issue.. I have 5
> chkboxes
> > > need to know if more than 1 is chec
> > >
> > >
> > >
> > >
> > >
> > > Puns are hard ot convey in written form. It's like trying to give away
> dead
> > > batteries at no charge.
> > >
> > > Bill
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com> , Liz Ravenwood
> > > <liz_ravenwood@> wrote:
> > > >
> > > > OH! Now.... I get it. I'm missing the necessary intonation I would get
> if
> > > delivered verbally. Duh.
> > > >
> > > > Liz Ravenwood
> > > > Database Developer / Programmer
> > > > Super First Class Products
> > > > B/E Aerospace
> > > > O: 1.520.239.4808
> > > > www.beaerospace.com
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill
> Mosca
> > > > Sent: Tuesday, September 13, 2011 1:40 PM
> > > > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > Subject: [MS_AccessPros] Re: Logic/SQL/Checkbox issue.. I have 5
> chkboxes
> > > need to know if more than 1 is chec
> > > >
> > > > Well, I think *I* was the one who got it, not her.<g>
> > > >
> > > > bill
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com> , Liz Ravenwood
> > > <liz_ravenwood@> wrote:
> > > > >
> > > > > Funny how sometimes we get it an some times we don't. :-)
> > > > >
> > > > >
> > > > > Liz Ravenwood
> > > > > Database Developer / Programmer
> > > > > Super First Class Products
> > > > > B/E Aerospace
> > > > > O: 1.520.239.4808
> > > > > www.beaerospace.com
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill
> Mosca
> > > > > Sent: Tuesday, September 13, 2011 1:14 PM
> > > > > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > Subject: [MS_AccessPros] Re: Logic/SQL/Checkbox issue.. I have 5
> > > chkboxes need to know if more than 1 is chec
> > > > >
> > > > > Liz
> > > > >
> > > > > I tell my wife my dad thought I was so bright he called me "Sun".
> She
> > > says, "That's 'son', dummy!"
> > > > >
> > > > > Bill
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com> , Liz Ravenwood
> > > <liz_ravenwood@> wrote:
> > > > > >
> > > > > > Bill, you are brilliant. Btw... I'm snagging that code for when a
> > > report has no data bit. That's good stuff too.
> > > > > >
> > > > > > Liz Ravenwood
> > > > > > Database Developer / Programmer
> > > > > > Super First Class Products
> > > > > > B/E Aerospace
> > > > > > O: 1.520.239.4808
> > > > > > www.beaerospace.com
> > > > > >
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill
> Mosca
> > > > > > Sent: Tuesday, September 13, 2011 1:03 PM
> > > > > > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > Subject: [MS_AccessPros] Re: Logic/SQL/Checkbox issue.. I have 5
> > > chkboxes need to know if more than 1 is chec
> > > > > >
> > > > > > Terence
> > > > > >
> > > > > > Try this:
> > > > > > SELECT *
> > > > > > FROM tbl_profile
> > > > > > WHERE (AI + AS + AA + NH + WH) < -1
> > > > > >
> > > > > > If only one is selected the outcome would be -1. If more than one
> are
> > > selected the sum would be anywhere from -2 through -5.
> > > > > >
> > > > > > The above would of course need to be edited if you ever added
> another
> > > ethinic field.
> > > > > >
> > > > > > Regards,
> > > > > > Bill Mosca, Founder - MS_Access_Professionals
> > > > > > http://www.thatlldoit.com
> > > > > > Microsoft Office Access MVP
> > > > > > https://mvp.support.microsoft.com/profile/Bill.Mosca
> > > > > >
> > > > > >
> > > > > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > <mailto:MS_Access_Professionals%40yahoogroups.com> , "Terence"
> > > <buffalome90210@> wrote:
> > > > > > >
> > > > > > > I dont have a lot of room to move on this issue because I am
> dealing
> > > with Fed Standards. I have 5 check boxes, as follows
> > > > > > >
> > > > > > > American Indian or Alaskan native
> > > > > > > Asian
> > > > > > > African American
> > > > > > > Native Hawaiian or Other Pacific Islander
> > > > > > > White
> > > > > > >
> > > > > > > I pass the data several times with a typical query such as:
> > > > > > >
> > > > > > > mysql = "select * from tbl_profile where (AI = True and AS =
> False
> > > and AA = False and NH = False and WH = False)"
> > > > > > >
> > > > > > > I have to allow the partipant to click more than one box (Fed
> > > Standard)
> > > > > > >
> > > > > > > I need a query to select when more than one of the boxes is
> checked.
> > > > > > >
> > > > > > > I can't use a custom control because I must allow multiple
> > > selections.
> > > > > > >
> > > > > > > If I have to I could put some logic in, but I was hoping to find
> a
> > > better way.
> > > > > > >
> > > > > > > all i can see is something like
> > > > > > >
> > > > > > > COUNT = 0
> > > > > > > If AI = true then COUNT = COUNT + 1
> > > > > > > If AS = true then COUNT = COUNT + 1
> > > > > > > If AA = true then COUNT = COUNT + 1
> > > > > > > If NH = true then COUNT = COUNT + 1
> > > > > > > If WH = true then COUNT = COUNT + 1
> > > > > > >
> > > > > > > If COUNT > 1 then
> > > > > > > msgbox("I got more than 1 box")
> > > > > > > endif
> > > > > > >
> > > > > > >
> > > > > > > ANY SUGGESTIONS ?
> > > > > > > Terence
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > ------------------------------------
> > > > > >
> > > > > > Yahoo! Groups Links
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > This email (and all attachments) is for the sole use of the
> intended
> > > recipient(s) and may contain privileged and/or proprietary information.
> Any
> > > unauthorized review, use, disclosure or distribution is prohibited. If
> you
> > > are not the intended recipient, please contact the sender by reply
> e-mail
> > > and destroy all copies of the original message.
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > Yahoo! Groups Links
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > This email (and all attachments) is for the sole use of the intended
> > > recipient(s) and may contain privileged and/or proprietary information.
> Any
> > > unauthorized review, use, disclosure or distribution is prohibited. If
> you
> > > are not the intended recipient, please contact the sender by reply
> e-mail
> > > and destroy all copies of the original message.
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > > > This email (and all attachments) is for the sole use of the intended
> > > recipient(s) and may contain privileged and/or proprietary information.
> Any
> > > unauthorized review, use, disclosure or distribution is prohibited. If
> you
> > > are not the intended recipient, please contact the sender by reply
> e-mail
> > > and destroy all copies of the original message.
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>