Script to Perform Find and Omit records that have a checked check box

[ACCAdmin]

I am out of ideas! I have a layout that performs a find of only requests for a certain day. But I want this find to omit the records that have a certain field checked. I named this field "semester request". In other words, this field is a check box and if the box is checked in the record, I want to omit the record from the find.

For this step of the script, I tried to put Perform find and then in Specify find, first action is Date Needed [//today's date] then next action is omit records [semester request] and criteria is @ (one character). This didn't work. I can't think of another way to indicate the criteria to omit a checked check box.

I also tried adding a script under the Found Sets using Omit Multiple Records, but it requires a number (the calculation must yeild a number?) so this didn't work. Maybe there's a calculation I don't know here.

Hope this makes sense! Thanks for your help and reply! ;)

[comment]

What is the value list attached to the checkbox field?

[ACCAdmin]

The value is a custom value, with actually only one value called "Semester Request". I am thinking I need to figure out how to set a field to select check box or radio button.

Many Thanks! :qwery:

[comment]

Well, "Semester Request" is more than one character, which is what you were looking for. So either look for "Semester Request" specifically, or use the "*" wildcard.