Macros and Programming


CardboxForumsMacros and Programming > "Searching for Null"

Searching for Null

Does anyone know what the code would look like if you wanted to search for null values in a field?

Posted By Post


24-Mar-2006 08:45

I want to automate a search where it will find all the records which have no date in a field called Date Returned. Does anyone have any suggestions?

Charles Welling

24-Mar-2006 09:14

Don't search for null, but exclude everything not being null.
Like this:

Exclude "DATE_RETURNED", "0:"

This will exclude all records containing a date, so it returns all empty ones.


© 2010 Cardbox Software Limited   Home