search for non-blanks

[BetterDayz]

Hi there,

This is probabbly an extremely basic question but I've been at it for the longest time. How would one make a script to search for for fields that aren't blank? Basically, I have a database with records of shot numbers. I want to do a search for completed shots. Those completed shots would have the completion date in the completion field instead of having a blank field.

Any help would be appreciated.

Thanks

[Lee Smith]

In "Find" mode, put an = equal sign in the field of choice and click the "Omit" checkbox. this will find all records that are blank in that field and then omit them, leaving you with all records with entry in the field.

HTH

Lee

[DykstrL]

You can also put in ">0" in the field. This will work on text and number fields. It won't work on date or time fields.