Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =iif(len(trim(Fields!txtMobile1.Value))<>0 and Fields!PupilHomeRel.Value="Parents","Fathers Mobile No: "&cstr(Fields!txtMobile1.Value)&" ","")
- &iif(len(trim(Fields!txtMobile2.Value))<>0 and Fields!PupilHomeRel.Value="Parents","Mothers Mobile No: "&cstr(Fields!txtMobile2.Value)&" ","")
- &iif(len(trim(Fields!txtMobile1.Value))<>0 and left(Fields!PupilHomeRel.Value,6)="Father","Fathers Mobile No: "&cstr(Fields!txtMobile1.Value)&" ","")
- &iif(len(trim(Fields!txtMobile1.Value))<>0 and left(Fields!PupilHomeRel.Value,6)="Mother","Mothers Mobile No: "&cstr(Fields!txtMobile1.Value)&" ","")
- &iif(len(trim(Fields!txtMobile1.Value))<>0 and left(Fields!PupilHomeRel.Value,6)="Stepfa","Stepfathers Mobile No: "&cstr(Fields!txtMobile1.Value)&" ","")
- &iif(len(trim(Fields!txtMobile1.Value))<>0 and left(Fields!PupilHomeRel.Value,6)="Stepmo","Stepmothers Mobile No: "&cstr(Fields!txtMobile1.Value)&" ","")
- &iif(len(trim(Fields!txtMobile2.Value))<>0 and right(Fields!PupilHomeRel.Value,7)=" Mother","Mothers Mobile No: "&cstr(Fields!txtMobile2.Value)&" ","")
- &iif(len(trim(Fields!txtMobile2.Value))<>0 and right(Fields!PupilHomeRel.Value,7)=" Father","Fathers Mobile No: "&cstr(Fields!txtMobile2.Value)&" ","")
- &iif(len(trim(Fields!txtMobile2.Value))<>0 and right(Fields!PupilHomeRel.Value,7)="pmother","Step Mothers Mobile No: "&cstr(Fields!txtMobile2.Value)&" ","")
- &iif(len(trim(Fields!txtMobile2.Value))<>0 and right(Fields!PupilHomeRel.Value,7)="pfather","Step Fathers Mobile No: "&cstr(Fields!txtMobile2.Value)&" ","")
- &iif(len(trim(Fields!txtMobile1.Value))<>0 and (Fields!PupilHomeRel.Value<>"Parents"
- and left(Fields!PupilHomeRel.Value,6)<>"Father"
- and left(Fields!PupilHomeRel.Value,6)<>"Mother"
- and left(Fields!PupilHomeRel.Value,4)<>"Step"
- and right(Fields!PupilHomeRel.Value,6)<>"Mother"
- and right(Fields!PupilHomeRel.Value,6)<>"Father"),cstr(Fields!PupilHomeRel.Value)&"s Mobile No: "&cstr(Fields!txtMobile1.Value)&" ","")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement