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...