cpking

Find record with field not equal to...

Discussion created by cpking on Sep 26, 2018
Latest reply on Sep 26, 2018 by philmodjunk

This should be really simple, and I'm finding it's really not...

 

I have a registration database where one field describes the type of registration (i.e., Standard, nonpaid, sponsored, cancelled, etc.).  I want to find all records where the registration is not equal to "cancelled."

 

How do I do this? Both in a layout, and in a script. Apparently both are possible, and both are handled differently.

 

Thanks, anyone, for your help!!!

Outcomes