Home

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?

Current user: [none]
Register / Log In · Help

Posted By Post

mjprog

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.

Charles

Quick Reply

Please log in or register before trying to post a reply.

 
© 2010 Cardbox Software Limited   Home