Formula = "XXXXXXX"+RIGHT({tblCustomer.MobileNo},3) Example - XXXXXXX048
Formula = mid({tblCustomer.MobileNo},4,5,)
Formula = len({tblCustomer.MobileNo})
Formula = int(currentdate - {tblCustomer.DOB})/365.25
how to given space S/O NASEER AHMADS/OBASHEER
Formaila = TRIM(Replace({Command.Name}," "," ")
Result = NASEER AHMAD S/O BASHEER
No comments :
Post a Comment