nicbak13
asked on
How do I insert a field in the middle of a text string in a formula
No doubt a simple question, but I can't work out the syntax.
I have a formula that asks if a field has data, then print a text line with another data field within the text. Exact example is:
if {CAC_database_field1} <> 0.00 then
'A part payment of {CAC_Database_field2} has been allocated'
I have tried splitting the text, inserting () around the datafield but can't seem to pick the right syntax.
Can someone put me on the straight and narrow.
Thanks
I have a formula that asks if a field has data, then print a text line with another data field within the text. Exact example is:
if {CAC_database_field1} <> 0.00 then
'A part payment of {CAC_Database_field2} has been allocated'
I have tried splitting the text, inserting () around the datafield but can't seem to pick the right syntax.
Can someone put me on the straight and narrow.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.