Text inside an evaluate calculation
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... :)