Can Custom Views Have Totals on a Field Instead of the Count?

[Guest]

I have a custom field called "Attendance" which is a number field where I
enter the number of attendees during a speaking presentation on a journal
form. I would like to group by category (which are presentation subjects)
and instead of a count of the group items next to the category, I'd like a
total of the attendees field.

Three questions:
1. Is this possible?
2. Are there better ways of doing this?
3. Are there any examples of views used to summarize information (with
totals etc.) somewhere?

Specs: Using Outlook 2003 on Windows XP, a Custom PST file has been created
for this application. The Speaking Folder in this PST has a custom form,
which was a modified journal form (tab 2), with the new custom field
"Attendees".

 

[Sue Mosher [MVP-Outlook]]

No, Outlook views cannot summarize information like that. A workaround would be to copy and paste from the table view to Excel and do the summary there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Is there a way to create a dynamic link to the information from the Journal
to the Excel Spreadsheet?

 

[Sue Mosher [MVP-Outlook]]

No.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers