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:

"PRICE_RISE" > 10 AND "PERCENTAGE_RISE" > 50

 

however, this returns an invalid sql statement...

Outcomes