Sum population by wards

[Clive Swan]

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

[Steve]

Re: Sum population by wards

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" <cliveswan@yaho o.co.ukwrote in message
news:fb5bb312-b22e-4581-942d-0c1099bc3950@59 g2000hsb.google groups.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