4 Replies Latest reply on Oct 14, 2010 9:04 AM by mootles22

    Text inside an evaluate calculation

    mootles22

      Title

      Text inside an evaluate calculation

      Post

      Hi there,

      I have two fields called "OrgName" and "OrgType" and I need to create a printout with these two fields combined and central on the page, with a hyphen in between, so that they will look like this:

      Organisation Name - Organisation Type

      So far, I have a calculation field - "Org_Full" - which is defined by the following formula:

      Org_Full = Evaluate ( "Org_Name & \" \" & Org_TypeDenom" ; [Org_Name ; Org_TypeDenom] )

      I've played around with speech marks like " - " and the like but can't seem to get it working.

      It's pretty simple I know but I just can't see it! Maybe I would be better off with something other than evaluate?

      Thanks in advance... :)