find records where the field is empty

[Jessica_BLUE]

Hi again, i have another question. im making a report, and i want to find all the trailer's in a given date range, whom don't have sales order, i guess the simple way to do this is with IsEmpty Function and a Constrain Found Set, i got

Enter Find Mode

Set field[EndDate;BeginDate...EndDate]

Set Field[status;"Inactive"]

Perform Find

Constrain Found Set

what i dont know is how to join these 2 functions? am i doing it wrong?

[Raybaudi]

Hi

if I understand you correctly:

Enter Find Mode

Set field[Date;BeginDate...EndDate]

New Record/Request

Set Field[status;"Inactive"]

Perform Find

[Jessica_BLUE]

no, what i want is to find all the records in a given date range, which doesnt have an sales order, so i think it would be with IsEmpty function, to check the field, and those who are empty, are the records i want, what i don't know how to do is join that function with a constrain found set, also if this is the correct way to do this.

[Raybaudi]

Enter Find Mode

Set field[Date;BeginDate...EndDate]

New Record/Request

Set Field[sales order;"="]

Perform Find

[Jessica_BLUE]

Thanks a lot! that was really easy. thanks again for your help

[Raybaudi]

Now you can try to make the script shorter, only one step:

Perform find [ Restore ]