Hello All,

I am looking for a little help on how to write a script to constrain a found set. I have a date range find for a report on sales person activities. So I do a find on the date range but I would like to omit the "House" records.

Enter Find Mode[]

Set Field [sets::date_ass;Admin_Reports::xdate_beg&"..."&Admin_Reports::xdate_end]

Perform Find[]

From here, how would I find all the records within the date range assigned to house and omit them?

Thanks

You can do it all at once:

Enter Find Mode[]

Set Field [sets::date_ass;Admin_Reports::xdate_beg&"..."&Admin_Reports::xdate_end]

[color:blue]New Record/Request

Set Field [ SomeField ; "House" ]

Omit Record

Perform Find[]

Perfect. Thank You :)