![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
Hello,
I'm trying to concatenate some text with a field in the properites of the fields and it's not working. Any help on syntax? "text "&[Total] Thanks Joel |
#2
|
|||
|
|||
![]()
Details please: This is for a formula on a custom form? Total is the exact name of a field on that form?
Start by putting a space between & and the field name. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Joel Allen" wrote in message ... Hello, I'm trying to concatenate some text with a field in the properites of the fields and it's not working. Any help on syntax? "text "&[Total] Thanks Joel |
#3
|
|||
|
|||
![]()
Yes Sue, it is a custom field in a custom form. Within the properites, I
want to set the intial value of the field to test + [Total], where Total is another custom field. End result would be test$1.00. Thanks, Joel "Sue Mosher [MVP-Outlook]" wrote in message ... Details please: This is for a formula on a custom form? Total is the exact name of a field on that form? Start by putting a space between & and the field name. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Joel Allen" wrote in message ... Hello, I'm trying to concatenate some text with a field in the properites of the fields and it's not working. Any help on syntax? "text "&[Total] Thanks Joel |
#4
|
|||
|
|||
![]()
Still looking for details. What is test supposed to be -- a static text string? Total is a currency field?
End result would be test$1.00. Only if the initial value for Total is $1.00. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Joel Allen" wrote in message ... Yes Sue, it is a custom field in a custom form. Within the properites, I want to set the intial value of the field to test + [Total], where Total is another custom field. End result would be test$1.00. Thanks, Joel "Sue Mosher [MVP-Outlook]" wrote in message ... Details please: This is for a formula on a custom form? Total is the exact name of a field on that form? Start by putting a space between & and the field name. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Joel Allen" wrote in message ... Hello, I'm trying to concatenate some text with a field in the properites of the fields and it's not working. Any help on syntax? "text "&[Total] Thanks Joel |
#5
|
|||
|
|||
![]()
In article , Joel Allen wrote:
I'm trying to concatenate some text with a field in the properites of the fields and it's not working. Any help on syntax? "text "&[Total] go to www.outlookcode.com and search for examples of how to use formulas. -- Hollis Paul Mukilteo, WA USA |
Thread Tools | Search this Thread |
Display Modes | |
|
|