Hi There, I have a report in an Access Database that prints off onto a pre-formatted page. I am trying to get the area code, mid three numbers, and last three numbers in the correct position. What is returning however, is not the correct numbers. The record from the query that populates this form is called HomePhone. This is what I have in the area I want to return an area code:
=Mid([HomePhone],2,3) I am getting the last number of the area code and the first two numbers of the middle three
This is what I have in the field that puts the remaining seven numbers:
=Mid([HomePhone],7,3) & Mid([HomePhone],10,5) I am getting only the last four numbers of the phone number.
Doesn't make sense to me. Thanks in advance for your help :-)
Start Free Trial
