Microsoft Access help

I am wanting to add up numbers in different records of the 'Amount of People' column, as a query. I'm not really sure how to go about this though, if it can even be done. My question is, can this be done? Thanks

geek_nzlotrfan, Apr 13, 2:34 pm

What version do you have?

geek_johnlyn, Apr 13, 2:41 pm

Is all the data in the field "amount of people" a number?

geek_bob7771, Apr 13, 2:42 pm

I have the 2007 version... . And yes all the data are numbers only.

geek_nzlotrfan, Apr 13, 2:51 pm

well, what I would do is create a new query, add the field with the numbers to the design grid and using the totals select the sum option to generate a total

geek_bob7771, Apr 13, 3:02 pm

Finally managed to get a solution. Thanks for your input!

geek_nzlotrfan, Apr 13, 3:48 pm