Calculation Help!!

i am sure this has been asked many many many times but i am a newbie when it comes to access. so here goes.

the problem i am having is i am trying to get a total number out of a single column for ex.

name.......sales.......hours.......sph......total sales
joe b 2 4 .50 2
mike r 2 4 .50 2
tom k 2 4 .50 2
total 6 12 6
what i want is the over all total of column 2 (sales) if that makes any sence let me know and if not let me know, i will email you the database so you can check it out.


i am trying to do it in a query the rows that i have are:

employee sales hours sph comments spif total sales

i just want to add the sales column/field and get a total in a text box on my main form.

i tried what you said and it just puts individual sales over in the total field i need it to put total sales of all employees as one big number.


thanks

rtfm