Advertisement
Guest User

Untitled

a guest
Aug 30th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. =iif(len(trim(Fields!txtMobile1.Value))<>0 and Fields!PupilHomeRel.Value="Parents","Fathers Mobile No: "&cstr(Fields!txtMobile1.Value)&" ","")
  2. &iif(len(trim(Fields!txtMobile2.Value))<>0 and Fields!PupilHomeRel.Value="Parents","Mothers Mobile No: "&cstr(Fields!txtMobile2.Value)&" ","")
  3. &iif(len(trim(Fields!txtMobile1.Value))<>0 and left(Fields!PupilHomeRel.Value,6)="Father","Fathers Mobile No: "&cstr(Fields!txtMobile1.Value)&" ","")
  4. &iif(len(trim(Fields!txtMobile1.Value))<>0 and left(Fields!PupilHomeRel.Value,6)="Mother","Mothers Mobile No: "&cstr(Fields!txtMobile1.Value)&" ","")
  5. &iif(len(trim(Fields!txtMobile1.Value))<>0 and left(Fields!PupilHomeRel.Value,6)="Stepfa","Stepfathers Mobile No: "&cstr(Fields!txtMobile1.Value)&" ","")
  6. &iif(len(trim(Fields!txtMobile1.Value))<>0 and left(Fields!PupilHomeRel.Value,6)="Stepmo","Stepmothers Mobile No: "&cstr(Fields!txtMobile1.Value)&" ","")
  7. &iif(len(trim(Fields!txtMobile2.Value))<>0 and right(Fields!PupilHomeRel.Value,7)=" Mother","Mothers Mobile No: "&cstr(Fields!txtMobile2.Value)&" ","")
  8. &iif(len(trim(Fields!txtMobile2.Value))<>0 and right(Fields!PupilHomeRel.Value,7)=" Father","Fathers Mobile No: "&cstr(Fields!txtMobile2.Value)&" ","")
  9. &iif(len(trim(Fields!txtMobile2.Value))<>0 and right(Fields!PupilHomeRel.Value,7)="pmother","Step Mothers Mobile No: "&cstr(Fields!txtMobile2.Value)&" ","")
  10. &iif(len(trim(Fields!txtMobile2.Value))<>0 and right(Fields!PupilHomeRel.Value,7)="pfather","Step Fathers Mobile No: "&cstr(Fields!txtMobile2.Value)&" ","")
  11. &iif(len(trim(Fields!txtMobile1.Value))<>0 and (Fields!PupilHomeRel.Value<>"Parents"
  12.                                             and left(Fields!PupilHomeRel.Value,6)<>"Father"
  13.                                             and left(Fields!PupilHomeRel.Value,6)<>"Mother"
  14.                                             and left(Fields!PupilHomeRel.Value,4)<>"Step"
  15.                                             and right(Fields!PupilHomeRel.Value,6)<>"Mother"
  16.                                             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