Omit Records to show only 2 of 3 types of Records in Found Set

[dragonmaster]

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

[Vaughan]

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

[dragonmaster]

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