active or inacative

[darksniper]

I have a report that reads the due date from the form, then compares it with todays date, then converts it into number and displays the list of students and the ammount of days they have left from -n... to +n..., the only problem Is that some student go away and come back in one or two month and I dont want them to show up in the report but let them stay in the system, so I have added a yes/no switch box, but I cannot get it to work with the report, to show the student that are only switched on( means active). anyone got an idea?

 

[ListO]

Yes.

Presuming that your report is based on a query, simply filter out students who's switch is set to false.

In the query, enter the yes/no field, fill in the criteria as FALSE, and un-check the SHOW box for that field. Then your report will only receive records who's yes/no box is set to no (unchecked).

 

[darksniper]

thx.I did it somewhat similar.