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
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