HughSMcKee
Apr 12 2011, 12:37 PM
I need to change the phone number from (714)555-1212 to display on a text report as 917145551212. How would I go about doing this?
RAZMaddaz
Apr 12 2011, 12:48 PM
Did you want to do this in a report in a text box? If so, enter the Following:
=91&MID([YourFieldName],2,3)&MID([YourFieldName],6,3)&RIGHT([YourFieldName],4)