D
Daniel
Hello
I store phone numbers in my table in numeric format (without parenthesis,...
- ie 5555555555). In my forms I use an input mask to make it more user
friendly (555) 555-555. However, now I'm trying to put together a simple
report and would like to know if there is a simple way to display the phone
number per the form (555) 555-5555 or if I have to use left() and right()...
to extract the info into the appropriate position? Am I missing something
really obvious (feels like I must be)?
Thank you,
Daniel P
I store phone numbers in my table in numeric format (without parenthesis,...
- ie 5555555555). In my forms I use an input mask to make it more user
friendly (555) 555-555. However, now I'm trying to put together a simple
report and would like to know if there is a simple way to display the phone
number per the form (555) 555-5555 or if I have to use left() and right()...
to extract the info into the appropriate position? Am I missing something
really obvious (feels like I must be)?
Thank you,
Daniel P