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.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"ShellBell" <(E-Mail Removed)> wrote in message news:C647CD6C-1542-45BC-A93D-(E-Mail Removed)...
> 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.
>
>

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...


"Sue Mosher [MVP-Outlook]" wrote:

> 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.
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "ShellBell" <(E-Mail Removed)> wrote in message news:C647CD6C-1542-45BC-A93D-(E-Mail Removed)...
> > 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.
> >
> >
>

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
http://www.outlookcode.com/jumpstart.aspx


"ShellBell" <(E-Mail Removed)> wrote in message news:8EB0335F-0698-427C-93C1-(E-Mail Removed)...
> 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...
>
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> 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.
>>
>> "ShellBell" <(E-Mail Removed)> wrote in message news:C647CD6C-1542-45BC-A93D-(E-Mail Removed)...
>> > 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.