Someone123
New member
- Local time
- Today, 08:17
- Joined
- Nov 28, 2007
- Messages
- 6
Thanks for any replies.
Unfourtunately, I'm using MS access 97, and cannot upgrade.
I have a report with time values stored in short format (eg, 12:00) representing durations in hours:minutes. The report also uses a date field to sort the entries by Month, Week and Day. I would like to have a total of the time durations added together at the beginning or end of each grouping level. If I try using the sum() function, Access reports that the data is the wrong format. Additionally, during the report wizzard, the time fields are not displayed as a summary option. Would it be possible to have my totals for the time durations, perhaps as: 172:21 or something similar?
- Someone123
Unfourtunately, I'm using MS access 97, and cannot upgrade.
I have a report with time values stored in short format (eg, 12:00) representing durations in hours:minutes. The report also uses a date field to sort the entries by Month, Week and Day. I would like to have a total of the time durations added together at the beginning or end of each grouping level. If I try using the sum() function, Access reports that the data is the wrong format. Additionally, during the report wizzard, the time fields are not displayed as a summary option. Would it be possible to have my totals for the time durations, perhaps as: 172:21 or something similar?
- Someone123
