Good afternoon! I need some help filtering a report. I have 3 tables. Table 1 is my main "top level" table. Table 2 is the "mid level" table, and Table 3 is my low level table. For clarity, data is like this:
Table 1 data: 3.1, 3.2, 3.3...etc
Table 2 data: 3.1.1, 3.1.2, 3.1.3, 3.2.1, 3.2.2, 3.3.1, 3.3.2, … etc.
Table 3 data: 3.1.1[a], 3.1.1[b], 3.1.1[c], 3.1.2[a], 3.1.2[b], 3.1.3[a], 3.2.1[a], 3.2.1[b]… etc.
I have my report set to group and print the following on each page (among other things not relevant to this question):
Pg 1:
3.1
3.1.1
3.1.1[a]
Pg 2:
3.1
3.1.1
3.1.1[b]
And increments through Table 3's data which increments Table 2's data, which increments Table 1's data so my last page is:
3.5
3.5.6
3.5.6[d]
I have that part of the report working fine. There is also a ton more data that goes with each record, but I have not listed them here for brevity.
An enhancement request was put in to create a check box form to filter the report by the selected Table 1 field. I have the 5 checkboxes created on the form and a command button that opens the report, but I can't figure how to filter my report on the selected checkboxes.
The report is not based on a created query, but the record source for the report is a SELECT query from the tables. Any idea on how to filter the report?
Thanks!!