var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Concatenate Fields
Im trying to concatenate four fields from the same table
Pat_Ind: [PatInd1] & [PatInd2] & [PatInd3] & [PatInd4]
Unfortunately the fields in the table contain white spacing
hope you understand!
I try typing IS NULL in the criteria but it does remove them
Thanks in advance
try [PatInd1] + [PatInd2] + [PatInd3] + [PatInd4]
doesn't seem to be giving me the results I want...
Originally Posted by r937
It only shows results if all fields are populated ([PatInd1] to [PatInd4])..
What if column [PatInd3] is empy?
It will not show results from [PatInd1] and [PatInd1]
sorry, i guess i assumed null whereas you actually did mean empty
they literally contain a single space in them?
I guess you have to test for the value than add or not based on that outcome.