YES/NO Data Types In Queries

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
 
J

Jeff Boyce

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort options unavailable for column of data in query 2
Get total number of records within a crosstab query 4
Access Access Report Works on One Machine but not Another 3
Using Yes/No data type 8
query yes/no field 6
yes/no field in query 4
Need help getting query to reference a field in a subform 2
Yes/No Data Type 2

Top