If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Check Box query help
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 |
#2
|
|||
|
|||
Check Box query help
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 |
#3
|
|||
|
|||
Check Box query help
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 |
Thread Tools | |
Display Modes | |
|
|