By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,395 Members | 1,532 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,395 IT Pros & Developers. It's quick & easy.

Sum population by wards

P: n/a
Hi

I am trying to sum a population field that may have 140 records for
each Ward (example).

Any suggestions on the best way to do this.

I would like to have a unique record for each Ward with all the
records summed.

Thanks

Clive
Sep 26 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Create a query that includes the Ward and Population fields. Change the
query to a Totals query by clicking on the Sigma (looks like a capital E)
button in the menu at the top of the screen. Go down to the Population field
and change Group By to Sum. When you run the query you will get the sum of
the Population for each Ward.

Steve
"Clive Swan" <cl*******@yahoo.co.ukwrote in message
news:fb**********************************@59g2000h sb.googlegroups.com...
Hi

I am trying to sum a population field that may have 140 records for
each Ward (example).

Any suggestions on the best way to do this.

I would like to have a unique record for each Ward with all the
records summed.

Thanks

Clive

Sep 28 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.