Hi,

In my database, I have a report that shows every record in the db. Each record has a status associated with it, which is assigned from a value list. There are about 15 different status options.

What can I add to a script that would show every single record EXCEPT the records that have a status from one particular value in the list?

For example, I'd like my report to display every record except for the records with a status of "No Action Required".

Thanks for the help.

Put a find in your script with these steps:

Enter Find mode[no restore]

Set field [statusfield, "No Action Required"]

Omit Record

Perform Find[no restore]

great that did just the trick. Thanks.