AnsweredAssumed Answered

Need help with a definition query

Question asked by t.faull on Jun 22, 2016
Latest reply on Jun 29, 2016 by wwmiller68

I have a point shapefile with 2 columns. Each column contains numbers relating to price increases of a service. One column is how much the price has risen by (£) and the second column is what percentage it has risen by, compared to the original price.


I want the layer in ArcMap to only display points where the price rise is above 10 (£) AND the percentage is over 50 (%).


Using the definition query tab, perhaps it would look like:



however, this returns an invalid sql statement...