MadAtMicrosoft
Registered User.
- Local time
- Yesterday, 22:52
- Joined
- Sep 27, 2010
- Messages
- 18
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.
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.