Searching for records with information in it
I know that sounds vague but I want to pull up records for any entry that has information in a certain field, and leave behind any entries that don't have info in that field.
For example, I have a field called notes. Not all of the records have information in this field. So how do I pull up those that have info in it?
This can be done by script or manually:
enter find mode
enter an * in the notes field
Perform the find.
The scripted method is much the same:
Enter Find Mode  //clear pause check box
Set Field [Yourtable::NotesField ; "*"]
Set error capture [on]