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