Home > Using FileMaker Pro > Finding, sorting, and replacing data > Finding records > Finding empty or non-empty fields

Finding empty or non-empty fields

You can find fields that contain no data or some data.

To find empty or non-empty fields:

1.	Start a find request.

For more information, see Making a find request.

2.	Refer to the following table for examples of different ways to search for empty or non-empty fields.

 

To find fields that are	Enter this in the field
Not empty (i.e., fields that have data)	*
Empty	=

3.	When you’ve entered the find criteria that you want, click Perform Find in the status toolbar, or choose Requests menu > Perform Find.

Note  If any value is empty in a repeating field, then a search using “=” returns that field.