Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have two tables in a personal geodatabase and one of them has 13 records and 6 fields, the other has 118 records and 125 fields.

There is a relationship class between the two tables where the first table is the origin and the other (bigger) table is the destination.

What I need is to take the records satisfying a condition from the second table and sum those records and put into a new field in the origin table

share|improve this question

1 Answer 1

Assuming you have a 1-M relationship between the two tables:

  1. Open up the attribute table for your big table
  2. right-lick on the foreign key column, and select Summarize
  3. Select the fields that you need to do your statistics on and the statistics method (sum, avg, etc).
  4. It creates a new output table
  5. Join the output table back to your origin table.
  6. Open up the attribute table for your origin table.
  7. Right-click on the destination field from your origin table and have it calc to your output table's column

Hope it helps. JT

share|improve this answer
    
thank you that is help me alot –  mohamed nour eldien Mar 22 '12 at 11:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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