[GIS] Don’t display records with null values

arcgis-10.2arcgis-desktopdisplayshapefile

I have shapefile with 4000+ points and I would like to display only records that have values greater than zero in a specific column.

How do I stop ArcGIS from displaying all records including those that are null?

I've been trying to use the Display and Symbology options but can't seem to get rid of the points that are null, whatever I do they still show up, just without any color in them! I'm using ArcGIS 10.2.

Best Answer

Use definition query to hide the null data. Have a look at this help topic.

So you will need to put something like:

[Field Name] IS NOT 'NULL'

This will effectively remove the null data from your map project without altering the dataset itself.