Adding Monthly totals

[CMH_Evon]

Hi,
I want to total hours worked for each month. There are 3 types of hours, bonus, inside and outside. For each month worked, I need the separate data and then the accumulated data for the month, which will add up each month for a year end total. I'm not sure where to start. should I create a form or a query?
Evon

 

[apr pillai]

Create a Query like the sample SQL given below:

SELECT [TableName].Month,
 [TableName].Type,
 [TableName].Field3,
 [TableName].Field4,
 [TableName].Field5,
 Sum([TableName].Hours) AS TotalHours
FROM [TableName]
GROUP BY [TableName].Month, [TableName].Type;

and design a Report using the above Query as Source. On the Sorting and Grooping option select Month and Type fiellds for Sorting Order. Display the Group Header/Footer Sections of Month and Type. Insert Text Boxes in the Footer section of the Month-Group and Type-Group of the Report and write the expression =Sum([Hours]) to get the Total.