Display partial results when using combo box as control source

[tlynnjpeg]

To start, I'm modifying the MS-provided Students Database, Student Attendance
by Days report. It is broken down on a first level by the entry in a combo
box on the table (present, absent-excused, absent-unexcused, etc),; a second
level by student, a third level lists all days in that category, then a total
for each student. (That was a little confusing, I hope it makes sense.)

What I'm hoping to do is to display all of that EXCEPT those under the
"present" category (I don't need to see the 20 pages of when students were
there, only the 2 pages of when they weren't). I'm really not sure how,
though. Is it even possible to restrict results from a combo box control
source?

I have some experience with Access and SQL (but not VB at all), but I'd
still classify myself as a beginner most of the time. I'm using Access 2007.

Any help would be appreciated. Thanks.

 

[Duane Hookom]

Your experience with SQL should come in handy when you set a filter for the
report as a criteria (WHERE clause) in the report's record source query.