Filter Report from multiple listboxes??

[Guest]

I am creating a database for my special education department. Students can be assigned any, some, or all of the following categories; Special Ed, 504, At-Risk, or General Ed. In the student info table Special Ed, 504, At-Risk, and General Ed are seperately represented by a Yes/No.

The problem I have run into is trying to filter the reports.
***I need to be able to filter reports into Special Ed, 504, At-Risk, or General Ed as complete seperate reports (for example, a report of all At-Risk students regardless of whether they fall in or out of another category.
***I also need to be able to run reports that contain combinations of Special Ed, 504, At-Risk, or General Ed. (for example, a report of all students who qualify for both Special Ed and At-Risk, but not General Ed)

I have tried listboxes, whereas clauses, and every other thing I can find. I may need to change my student info table, but I am not sure anymore. Any and all suggestions are very welcome.

 

[Duane Hookom]

You stated "I may need to change my student info table". It would help if we
knew what your structure was.
Are you comfortable writing or modifying code? Do you have list box names
and field names (and types)?

--
Duane Hookom
MS Access MVP

I am creating a database for my special education department. Students

can be assigned any, some, or all of the following categories; Special Ed,
504, At-Risk, or General Ed. In the student info table Special Ed, 504,
At-Risk, and General Ed are seperately represented by a Yes/No.

The problem I have run into is trying to filter the reports.
***I need to be able to filter reports into Special Ed, 504, At-Risk,

or General Ed as complete seperate reports (for example, a report of all
At-Risk students regardless of whether they fall in or out of another
category.

***I also need to be able to run reports that contain combinations of

Special Ed, 504, At-Risk, or General Ed. (for example, a report of all
students who qualify for both Special Ed and At-Risk, but not General Ed)

I have tried listboxes, whereas clauses, and every other thing I can find.

I may need to change my student info table, but I am not sure anymore. Any
and all suggestions are very welcome.

 

[Guest]

field names field type
Spec ed Text (but the form is a check box, so the form reports a Yes/No
504 Text (but the form is a check box, so the form reports a Yes/No
at-risk Text (but the form is a check box, so the form reports a Yes/No
general ed Text (but the form is a check box, so the form reports a Yes/No

listbox name linked field listbox choice
filterbox1 Spec Ed Yes N
filterbox2 504 Yes N
filterbox3 At-Risk Yes N
filterbox4 General Ed Yes N

I am comfortable modifying code, but I am enough of a newbie that it is hard to come up with the coding myself. When I do read others coding, I can for the most part step through it and understand what is being done


----- Duane Hookom wrote: ----

You stated "I may need to change my student info table". It would help if w
knew what your structure was
Are you comfortable writing or modifying code? Do you have list box name
and field names (and types)

--
Duane Hooko
MS Access MV

I am creating a database for my special education department. Student

can be assigned any, some, or all of the following categories; Special Ed
504, At-Risk, or General Ed. In the student info table Special Ed, 504
At-Risk, and General Ed are seperately represented by a Yes/No

***I need to be able to filter reports into Special Ed, 504, At-Risk

or General Ed as complete seperate reports (for example, a report of al
At-Risk students regardless of whether they fall in or out of anothe
category

***I also need to be able to run reports that contain combinations o

Special Ed, 504, At-Risk, or General Ed. (for example, a report of al
students who qualify for both Special Ed and At-Risk, but not General EdI may need to change my student info table, but I am not sure anymore. An
and all suggestions are very welcome

 

[Duane Hookom]

I wouldn't go any further until the table was normalized. You are storing
data values in field names. What would you do if you need to add another
category? I expect you would have to add a field and then modify all your
forms and reports and queries. Ideally each "checked" box should be a record
in a related table.

Is there any possibility of changing your table structure?

--
Duane Hookom
MS Access MVP

field names field types
Spec ed Text (but the form is a check box, so the form reports a Yes/No)
504 Text (but the form is a check box, so the form reports a Yes/No)
at-risk Text (but the form is a check box, so the form reports a Yes/No)
general ed Text (but the form is a check box, so the form reports a Yes/No)

listbox name linked field listbox choices
filterbox1 Spec Ed Yes No
filterbox2 504 Yes No
filterbox3 At-Risk Yes No
filterbox4 General Ed Yes No

I am comfortable modifying code, but I am enough of a newbie that it is

hard to come up with the coding myself. When I do read others coding, I can
for the most part step through it and understand what is being done.