Can hours be sum?

[newtoAccess]

I am new To MS Access.



I am trying to total hours worked for the week.

Problem1: group by employee, and sum the hours for each employee per day.

The fields are StartTime, EndTime, HrsWrkDay, hrsWrkweek, the format is 00:00

I have the grouping done but the sum of the hours are not correct.
So can I sum time? or do I have to convert the daily time total to something else and then sum the daily?

If so How
NewToAccess

[June7]

You must calculate the elapsed time (DateDiff function) then sum the results.

All four fields are Date/Time fields?

If elapsed period crosses midnight, need to include date part in the calculated values.

[newtoAccess]

I do not under stand the help secton on this "DateDiff"?
DateDiff(interval, date1, date2 [, firstdayofweek] [, firstweekofyear] )
I am not sure where to put it?

I did this in a Query and it dissappeared
Dif_Date_test: DateDiff(1, SundayStartofweek, SaturdayEnd of week, , )

What am I doing wrong

[newtoAccess]

SELECT Hours_Worked.employee, Hours_Worked.[Complete date], Hours_Worked.StartTime, Hours_Worked.EndTime, Hours_Worked.TotalHours, Hours_Worked.TotalHours AS hrs_Dec, ([TotalHours]/1000) AS EmployeeHrs, DateDiff(1,[StartTime],[EndTime],0) AS date_Test
FROM Hours_Worked
WHERE (((Hours_Worked.[Complete date])>=[Forms]![Select_Wrk_Week]![StartofWeek] And (Hours_Worked.[Complete date])<=[Forms]![Select_Wrk_Week]![EndofWrkWeek]))
ORDER BY Hours_Worked.employee;

[June7]

So this is working? Issue solved?

[newtoAccess]

No it is not.

I need to "group by" employee name and have the group sum the hours worked for the week for each individule employee.
Any suggestions on how to do this?

[June7]

Build an Access report with Grouping & Sorting and aggregate calcs. Use the query you show as the RecordSource for the report. This is basic Access functionality and Access Help has guidelines.

[newtoAccess]

Can i use the results in the report for a different query?

[newtoAccess]

When I go to create a new query I do not see the report.
I need the results so I can do some other stuff.

How do I get the results so I can do other calculation?

[June7]

A query would be used as the RecordSource for a project. No, any calcs done with report Grouping and Sorting and aggregate calcs in headers/footers would not be available for use elsewhere.

To do summary calcs in query must do a Totals query. This will include a GROUP BY clause. Again, look at Access Help for guidelines on Totals (summary, aggregate) queries. Or review this http://office.microsoft.com/en-us/ac...010096310.aspx