ty Bill, that worked, odley enough I attempted using val(AS), Val(AA), etc....that resulted in a ZERO all the time.
Thanx again.
terence
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> 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, "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
> >
>
Tidak ada komentar:
Posting Komentar