Hide Records

[MyMelody]

Hi all,

I want to generate a report that displays the records of students who attended the class for certain dates and hides if  absent. For example, if Dave was absent last 10/01/2018, all records pertaining to him will be hidden.

I hope you can help me.

 

-MyMelody

[MayMusic]

You can create a report based on the attendance table and for the attendance date on the search form add Criteria  (3 of them) from the picker so you have two inputs

1. Date FROM  , Comparison type GREATER THAN OR EQUAL 
2. To,  Comparison type LESS THAN OR EQUAL 
3. Hidden, Comparison type not blank 

logical operator would be AND in between