Thread
:
How can I total on columns in a view?
View Single Post
#
3
June 25th 07, 09:14 PM posted to microsoft.public.outlook.calendaring
Jason R. Senior
external usenet poster
Posts: 1
How can I total on columns in a view?
Could I write a Macro within Outlook which at the click of the button could
generate a simple report for me?
"Sue Mosher [MVP-Outlook]" wrote:
The alternative is to export to Excel and run a pivot table. Outlook can't do math like that in views.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"Jason R. Senior" Jason R.
wrote in message ...
I have a simple view which has two columns. Subject and duration. I am
grouping on Subject. What I am trying to accomplish is this: I want total
hours worked on each Subject. My subjects are project numbers, such as
P-12345 and P-45678. I want the view to show P-12345 | 10 hours. Inside
that ten hours may be 5 different appointments, all with the Subject P-12345.
My view does properly group appointments by Subject, but surprisingly I see
no option in Outlook to total on a numeric field, such as duration. This
means I have to manually add up all the individual durations to get a total
duration.
Does anybody have any ideas short of exporting my calendar information into
Access?
Jason R. Senior
View Public Profile
View message headers
Find all posts by Jason R. Senior
Find all threads started by Jason R. Senior
Ads