I am a newbie with scripting. I have 3 types of records. I want to use a script to show all records and then omit two of the three types of records leaving just the one type I have a database for teaching with pass types.

There are 3 pass types General Pass, Nurse Pass, Dress Code Pass. I have a report layout and want to use a script to show all General Passes. To do this, I have to remove the Nurse Pass and Dress Code Pass records from the found set.

I have no problem omitting either Nurse Pass or Dress Code, but I cannot get it to omit both. I even wrote a separate script to omit Nurse pass and tried to use then a Perform Find omit records to omit the Dress Code Pass, but that did not work either.

Here is what I have.

Show All Records

Perform Find [Restore] Action Omit Records Student_Passes:Pass_Type= Dress Code Pass

Perform Find [Restore] Action Omit Records Student_Passes:Pass_Type= Nurse Pass

Go to Layout ["Student Pass List"(Student_Passes)]

Thanks,

Michael

Why not find the type you want in one step. No need to "show all records" first.

Vaughn,

Thanks. It helped me realize what the problem really was. For General Passes, there are sub-types such as Hall, Library, Water, etc. So I created a new field called Pass Types - General, Dress Code and Nurse. I then wrote a case statement so that each of the types Water, Library etc would return General to the field and Nurse would return Nurse and Dress Code would return Dress Code.

I was then able to do the find as you suggested. Thanks for helping me re-think the problem and create a solution.

Michael