AnsweredAssumed Answered

Text inside an evaluate calculation

Question asked by mootles22 on Oct 14, 2010
Latest reply on Oct 14, 2010 by 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... :)

Outcomes