Prev: Two records one row
Next: Help! Unmatched Data Query
From: Steph on 5 May 2010 10:30
Morning all, looking for some more help from my gurus.

What I have:

A table with 4 or 5 text fields, and 8 Check Boxes.

What I want: A query that will allow me to Query a couple of those check
boxes that will return both.

IE: one box - Simple
Two checked, - return records with BOTH check boxes selected.

As always, thanks in advance.

Steph
From: Steph on 5 May 2010 10:56
While i am being greedy, what would be my ideal situation is to have say, an
Option Group with my checkboxes in it, and when checkboxes are selected, my
form (or subform) is automatically filtered without leaving the form.

Is this possible?

Thanks again!

"Steph" wrote:

> Morning all, looking for some more help from my gurus.
>
> What I have:
>
> A table with 4 or 5 text fields, and 8 Check Boxes.
>
> What I want: A query that will allow me to Query a couple of those check
> boxes that will return both.
>
> IE: one box - Simple
> Two checked, - return records with BOTH check boxes selected.
>
> As always, thanks in advance.
>
> Steph
From: KARL DEWEY on 5 May 2010 15:17
>>What I want: A query that will allow me to Query a couple of those check
boxes that will return both.
So why not put an unbound checkbox for each in the form header to use as
criteria?
My_Calculated_Field: IIF([Forms]![YourForm]![Cbo1] =-1 AND Table1.Cbo1 =-1,
1, 0) + IIF([Forms]![YourForm]![Cbo2] =-1 AND Table1.Cbo2 =-1, 1, 0) + ...

Criteria --
>= IIF([Forms]![YourForm]![Cbo1] =-1, 1, 0) +
IIF([Forms]![YourForm]![Cbo2] =-1, 1, 0) + ...

>>an Option Group with my checkboxes in it,
An Option Group uses a single field to store the data and only one of its
boxes can be checked at a time.


--
Build a little, test a little.


"Steph" wrote:

> While i am being greedy, what would be my ideal situation is to have say, an
> Option Group with my checkboxes in it, and when checkboxes are selected, my
> form (or subform) is automatically filtered without leaving the form.
>
> Is this possible?
>
> Thanks again!
>
> "Steph" wrote:
>
> > Morning all, looking for some more help from my gurus.
> >
> > What I have:
> >
> > A table with 4 or 5 text fields, and 8 Check Boxes.
> >
> > What I want: A query that will allow me to Query a couple of those check
> > boxes that will return both.
> >
> > IE: one box - Simple
> > Two checked, - return records with BOTH check boxes selected.
> >
> > As always, thanks in advance.
> >
> > Steph
 | 
Pages: 1
Prev: Two records one row
Next: Help! Unmatched Data Query