Can I sum a field that appears in every record of address book?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello...

I've designed a custom form that includes several currency fields such as
TOTAL BILLINGS and TOTAL PAYMENTS... Can you please advise and/or direct me
to the method/procedure to allow me to somehow total these fields for all of
the contacts in an address book?

Running Outlook 2003 on SBS Server 2003...the address book is located in a
public folder.

Thank You.
 
You would need to iterate all the items in the folder and generate a running total. Your message isn't clear, though, on where you want this information to appear.
 
Thank you very much for your response. I would be looking to have this
"total" appear in an outlook view or report of some type. To clarify the
scenario, I have created custom forms which calculate the balance currently
due for each construction job in process...along with various other contract
details. I want to be able to provide my boss with a method to have this
field, and others, totalled. Right now, I have a view which details this
field and others....but no total at the bottom.

Please forgive the awkwardness of my questions, I am completely new to
programming in outlook...but have found the information on this board to be
very helpful.

I somewhat understand your response...can you please direct me to best
method to iterate?

Thanks in advance for your assistance...
 
An Outlook view can show only the items in the Outlook folder that you are viewing. Therefore, you'd need to be thinking about a "report of some type." It could be in Excel, in Word, or in just a simple message box that pops up.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top