select criteria query

select criteria query

I have a form for a 6 month period, January-June.

If a student comes in January, I mark the appropriate dates with a '1'.
If the same student is absent all February, for example, I mark the dates with '0'.

I set the criteria for all months to read 'display if date columns equal 1'.

Of course, it displays the student for January, but I expected it would not display that student in February, however, it does.

Is there a way around this ?

Thanks for any advice.