T
Tara
I'm hoping someone can help me with this. I have a table that holds basic
contact information as well as what part of our organization the person is a
part of. Since any person can be involved in several different areas, I
chose to use check boxes to indicate which groups they are a part of. I'm
trying to design a query where the user can click a check mark on a form to
indicate which group/groups they want to pull data on. So, if the user
clicks the box for our Business contacts and for our Agency contacts, the
report will only pull those people/contacts that have that area's check box
marked in their row in the table. I thought that maybe putting
[Forms]![FrmReports]![CK1], [Forms]![FrmReports]![CK2], etc. in each of the
query's criteria boxes would do the trick, but it isn't working. What other
options, aside from using make table and append queries do I have to get the
data that I want?
Thanks for any help!
contact information as well as what part of our organization the person is a
part of. Since any person can be involved in several different areas, I
chose to use check boxes to indicate which groups they are a part of. I'm
trying to design a query where the user can click a check mark on a form to
indicate which group/groups they want to pull data on. So, if the user
clicks the box for our Business contacts and for our Agency contacts, the
report will only pull those people/contacts that have that area's check box
marked in their row in the table. I thought that maybe putting
[Forms]![FrmReports]![CK1], [Forms]![FrmReports]![CK2], etc. in each of the
query's criteria boxes would do the trick, but it isn't working. What other
options, aside from using make table and append queries do I have to get the
data that I want?
Thanks for any help!