Addition in Formulas in Custom Outlook Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amy - 23 Dec 2003 20:21 GMT

I'm trying to add the values of two fields together. I
have no problem multiplying, subtracting and dividing, but
I can't figure out how to add.

In the Edit formula text box, I can enter the following
(and it works):
[field1] * [field2]

but when I try [field1] + [field2] it takes the two values
and puts them side by side ie. if I'm adding 10 and 20,
the result in 1020.

I would really appreciate it if anyone can let me know
what I'm doing wrong. Thanks!

Reply to this Message

Hollis D. Paul - 23 Dec 2003 21:41 GMT

> I would really appreciate it if anyone can let me know
> what I'm doing wrong. Thanks!

Its probably just a typo in the message, but the spaces you have around
the + operator may be causing the problem. You notice you don't have
them in the multiplicative example.

Hollis D. Paul [MVP - Outlook]
Hollis@outhousebythesound.com
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA

Reply to this Message

Amy - 23 Dec 2003 21:50 GMT

Yes it was just a typo - I've tried several times with a
space and without a space, and with the + it still doesn't
seem to work.

Thanks,
Aimee

>-----Original Message-----
>> I would really appreciate it if anyone can let me know
[quoted text clipped - 12 lines]
>
>.

Reply to this Message

Sue Mosher [MVP] - 23 Dec 2003 22:00 GMT

Sounds like you created those properties as text properties, not as numeric. If so, you'll need to convert them to numerics in order to be able to add them:

CInt([field1]) + CInt([field2] )

If they're not integers, then use the appropriate conversion function.

Signature

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

> I'm trying to add the values of two fields together. I
> have no problem multiplying, subtracting and dividing, but
[quoted text clipped - 10 lines]
> I would really appreciate it if anyone can let me know
> what I'm doing wrong. Thanks!

Reply to this Message