Group totals on a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I am using Access XP

I have an access table with the fields 'Staffid' 'Job No' 'Period'
'Activity' 'Time'
I created a query on this getting sum of Time grouped by
'Activity','JobNo','Period','Staffid'
I use this query in a report the report is grouped by Staffid, JobNo,
Period. The detail section uses the sum of Time for the Period for a Jobno
for a particular Staff. The Period footer shows the total of time for that
period (using a datasource of =Sum(sum of Time)). The JobNo shows the total
of time for that job for all periods for that staffid (again datasource is
=Sum(sum of Time)) and finally the Staff footer shows the total of time for
all jobs for all periods for the StaffID (again datasource = Sum(Sum of
Time). The totals are fine for period and job but the staff total is
completely wrong (sometimes not always).
Does anyone have any idea what might be wrong?
Grateful for any help.

Alan
 
Is this because your "time" sums to greater than 24 hours?
I would recommend that you store the amount of time in a field like
MinutesWorked. I try to use date/time fields for points in time rather than
durations of time.

BTW: Time is not a good name for a field since it is also the name of a
function.
 
Hi Duane

Thanks. I realised it is because the time worked has exceeded 24 hours!
Incidentally I had actually called the field TimeWorked!

Many thanks

Alan
 
Back
Top