Is it possible to sum fields together in the select by attribute tool with a SQL query?

I'm working in ArcMap 10.3.

closed as unclear what you're asking by PolyGeo Mar 31 '17 at 21:45

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Why do you want to do that? – BERA Mar 31 '17 at 18:44
  • 2
    What exactly are you trying to do? Please edit your question to give details of what you're trying to do, a bit of info about your data, and what you've tried. What would summing field values together in a Select by Attributes do? Usually you use a field calculator if you're trying to run calculations. – Midavalo Mar 31 '17 at 18:53

If you are wanting to select features based on 3 fields, if [Field 1] + [Field 2] = [Field 3], you can do a query that says exactly that. Put field1 + field2 = field3 into the WHERE clause (where field1 etc. are the names of your fields)

enter image description here

enter image description here

Or if you want to check that two fields add up to a specific value, eg if [Field 1] + [Field 2] = 57, again you just enter exactly that into the WHERE clause:

field1 + field2 = 57

Again, field1 etc. refers to your field names, and 57 is the value the values from the two fields need to add up to in order to be selected.

enter image description here

enter image description here

Not the answer you're looking for? Browse other questions tagged or ask your own question.