Hi...

I have a table where Field1 contains both positive and negative values. I have a need to search for a set of records where Field1's values are outside of a specific range, ex: -3 to +5. As the range doesn't fall evenly on a number line, I cannot use the ABS[] value and just seach for values greater than X.

Does anyone know of a way to execute a find (from within a script) to retrieve a set of records where Field1 is less than -3, and greater than +5? Is there a way to combine a NOT operator with the range span operator (...) from within a FIND[] step, from within a script?

Thanks in advance,

-KJ

Use the Omit Record step immediately after setting up the Find criteria. This is just like checking the Omit box in Find mode. For example:

Enter Find Mode []

Insert Text [select,numberField,"-3...5"]

Omit Record

Perform Find []

You could also find the range, then show omitted records, but it's a bit slower:

Enter Find Mode []

Insert Text [select,numberField,"-3...5"]

Perform Find []

Show Omitted

Copy_and_Paste_r2.zip

Thom,

Thank you, that works exactly like I need. Your help is much appreciated.

-KJ

Copy_and_Paste_r2.zip