concatenate

[Joel Allen]

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

 

[Sue Mosher [MVP-Outlook]]

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

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

 

[Hollis Paul [MVP - Outlook]]

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.

 

[Joel Allen]

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


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

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

 

[Sue Mosher [MVP-Outlook]]

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

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

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


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

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

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