YES/NO Data Types In Queries

  • Thread starter Thread starter Phrostyphish
  • Start date Start date
P

Phrostyphish

We have a form with a section labelled something along the
lines of "check all that apply." When running a query to
display a particular incident... what is the best
way "parameterize" the query so that only the options that
have been checked for that incident are displayed in the
report?

Thanks
 
You haven't described your data structure, just your form. It'll be a bit
tough to offer meaningful suggestions when we don't know if you have
multiple repeating fields (a very spreadsheetly thing to do, which could
translate directly over into your 'check all that apply' form design), or if
you have a parent/child (one-to-many) table relationship, where the number
of "child" records related to a parent row is the number of items checked
(an Access/relational database design).

More info, please...

Jeff Boyce
<Access MVP>
 
Back
Top