I'm trying to create a field in my Book Mark source file to go into a merge with a set of precedent documents
If the matter is in the Magistrates court i.e. len([CourtRefNo]) is > 0 I want to use the Court Location - CourtRefNo
If the [CourtRefNo] Has nothing in it I want to check the QcatRefNo and it it has nothing in it I just want a ' '
If the QcatRefNo has something in it I want to use the QcatLoaction and the QcatRefNo
Now that's the logic, my code is below
I have spread it out for clarity
Any help would be great
If the matter is in the Magistrates court i.e. len([CourtRefNo]) is > 0 I want to use the Court Location - CourtRefNo
If the [CourtRefNo] Has nothing in it I want to check the QcatRefNo and it it has nothing in it I just want a ' '
If the QcatRefNo has something in it I want to use the QcatLoaction and the QcatRefNo
Now that's the logic, my code is below
Code:
IIF(IsNull([CourtRefNo]) Or Len([CourtRefNo]) = 0,
IIF(IsNull([QcatRefNo]) Or Len([QcatRefNo]) = 0," ",
"QCAT - " & [QcatLocation] & " - " & [QcatRefNo],
"Court - " & [CourtLocation] & " - " & [CourtRefNo]))
I have spread it out for clarity
Any help would be great