AnsweredAssumed Answered

Find with "OR Not"

Question asked by sparrowsfall on Oct 11, 2017
Latest reply on Oct 12, 2017 by beverly

Hi all. Maybe I'm just not smart enough to deploy Omit requests logically, but I sure could use some help.

 

Think of a table of sales.

 

Each record has a sale date.

 

I want to find records where SaleDate is:

 

NOT 1/1/2017

OR

NOT 1/2/2017

OR

NOT 1/3/2017

 

Stacking up omit requests makes this an AND search. The set of found records gets progressively smaller.

 

I want the set of found records to get progressively bigger.

 

I'm dreaming of a != operator that I could enter in the field on the Find form, before the date...

 

Suggestions (and obvious solutions that I couldn't figure out) greatly appreciated.

Outcomes