concatenate

  • Thread starter Thread starter Joel Allen
  • Start date Start date
J

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
 
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
 
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
 
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.
Click to expand...

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


Joel Allen said:
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


Joel Allen said:
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
Click to expand...
Click to expand...
 
Back
Top