Calculating hell!!

  • Thread starter Thread starter david orm via AccessMonster.com
  • Start date Start date
D

david orm via AccessMonster.com

Hope someone can help with this [hopefully very easy]

I have a table that contains various information:

Name School Job Hours
smith
 
Hope someone can help with this [hopefully very easy]

I have a table that contains various information:

Name School Hours Hours1
smith high school 2 5
Jones a school 2 4
Clark primary 1 3

the hours and hours 1 column represent the length of time of different
activities carried out at the school by the relevant person. want i want to
be able to do is total all of the hours for either each school or each person
and as i am totally newish to access it is a bit fo a mystery...HEEELLPPPP!!!
 
Hope someone can help with this [hopefully very easy]

I have a table that contains various information:

Name School Hours Hours1
smith high school 2 5
Jones a school 2 4
Clark primary 1 3

the hours and hours 1 column represent the length of time of different
activities carried out at the school by the relevant person. want i want to
be able to do is total all of the hours for either each school or each person
and as i am totally newish to access it is a bit fo a mystery...HEEELLPPPP!!!
Click to expand...

Create a new Query based on your table.

Select either the school, or the person, whichever you want to total
by for this query (you'll need two queries to get separate totals).

Change the query to a Totals query by clicking the Greek Sigma icon -
looks like a sideways W.

Leave the default Group By on the field that you want to group by;
select the Hours fields and change the Totals operator to Sum.

Open the query by clicking the leftmost icon in the toolbar, or base a
Form or Report on the query; you'll see the sum for each name or for
each school.

John W. Vinson[MVP]
 
Back
Top