RE: Not sure I can do this.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

Unfortunately, there must be more than one checked for some of the records.
Is there a way around this?

Thanks

"Karen53" wrote:

> Hi,
>
> Ok, I know why they are inaccurate. Each record can have more than one
> check box True and I am only filtering to the value of one. So some of them
> are true and the filter is looking for false.
>
> "Karen53" wrote:
>
> > Hi,
> >
> > At first
> > Where field = NZ(Forms![FormName]![FieldName],0)
> > seemed to work but upon further checking I am not getting accurate results.
> > Any suggestions?
> >
> > "Karen53" wrote:
> >
> > > Hi,
> > >
> > > I am still having trouble.
> > >
> > > Where field = NZ(Forms![FormName]![FieldName],0)
> > > This works beautifully as long a check box is selected.
> > >
> > > If I add:
> > > Where field Like NZ(Forms![FormName]![FieldName],"*")
> > > I get nothing (check box not selected).
> > >
> > > If I put
> > > Where field = NZ(Forms![FormName]![FieldName],0)
> > > and a check box is not selected I only get 7 records when there should have
> > > been 66. Am I missing something? Sometimes I run this selecting a check box
> > > and sometimes without.
> > >
> > > Thanks for your help.
> > >
> > > "Karen53" wrote:
> > >
> > > > Thank you!
> > > >
> > > > "Ofer" wrote:
> > > >
> > > > > I check box can have two values , True and False, so if you didn't check it
> > > > > you need to filter on false.
> > > > >
> > > > > In that case try and use
> > > > > Where field = NZ(Forms![FormName]![FieldName],0)
> > > > >
> > > > > But if you want to select all the values if you didnt check the box, try and
> > > > > use
> > > > > Where field Like NZ(Forms![FormName]![FieldName],"*")
> > > > >
> > > > > --
> > > > > In God We Trust - Everything Else We Test
> > > > >
> > > > >
> > > > > "Karen53" wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > What I would like is a form with a combo box to filter a query. That I have
> > > > > > so far. But then I would like a series of check boxes. If one check box is
> > > > > > checked it filters for that check box in addition to my combo box. Where I
> > > > > > am getting hung up is each check box on the form has a matching boolean field
> > > > > > in the record. I have tried setting up the query for each check box to link
> > > > > > to the check box on the form. The trouble seems to be it can't be blank. I
> > > > > > get nothing when I query. So, I think I need to link only the check box I am
> > > > > > filtering to, which is variable. Can I place the link through VB onto the
> > > > > > query from the form based on which check box is selected?
> > > > > >
> > > > > > Thanks
.

Relevant Pages