Sum Time - Report uses Query Alias result

[MadAtMicrosoft]

I have a table of Time records, tblProjTime.

PKID,
CustomerID (lookup to tblCustomers),
with three additional fields,
a) Completed (Y/N);
b) StartDateTimeStamp (General Date = Now(),
c) EndDateTimeStamp (General Date = Now() when completed)

I have a form with queries that upon project completion the "Completed" field is set to 1 to indicate time is complete


In a select query I have an Alias TtlTime: tblProjTime.EndDateTimeStamp - tblProjTime.StartDateTimeStamp

That appears in my test data to be working. I set that fields default to "Short Time" That all displays correctly

However when I go to the Report rptProjTime it will print the individual time records correctly but will not SUM the time.

FIRST, Has anyone seen a problem wherein it doesn't calculate time difference as I explained above? This is Access 2007 if that makes any difference and it seems to be correct so far.

SECOND, Is there a way to sum that Alias time on a report or do I first have to use an {Event Procedure} to convert it to hrs, mins etc and add up those integers.

 

[gemma-the-husky]

time will sum ,but wont go over 24hrs

so 23 hours plus 4hrs is 3hrs - is that the problem you are having?

 

[MadAtMicrosoft]

time will sum ,but wont go over 24hrs

so 23 hours plus 4hrs is 3hrs - is that the problem you are having?

No. The report will list the customer, the starttime, the endtime and the alias time field. However when I go to the section footer the only option in totals is Count. Sum avg etc... Are disabled. In my test data one proj had two line items of 4:40 each. So it wouldn't be a > 24 hr issue.