N
Novice2000
Hello I have Access 2007.
Thanks to help from Doug Steele and Clifford Bass I now have a working
export query. I needed to export data to a Fixed Width - No delimiters -
ASCII Text File.
Everything is working well except for one thing the phone number is not
keeping its format. The expression is written like this:
Telephone_Number: Left([1st Phone] & Space$(13),13)
and it is displayed in the query like this: 8003982599
The criteria for the export is that it look like this: (800)398-2599 and
that is how it appears in the table used for the query. Can anyone help me
figure out how to write this expression to display the phone correctly?
Thank you for any assistance.
Thanks to help from Doug Steele and Clifford Bass I now have a working
export query. I needed to export data to a Fixed Width - No delimiters -
ASCII Text File.
Everything is working well except for one thing the phone number is not
keeping its format. The expression is written like this:
Telephone_Number: Left([1st Phone] & Space$(13),13)
and it is displayed in the query like this: 8003982599
The criteria for the export is that it look like this: (800)398-2599 and
that is how it appears in the table used for the query. Can anyone help me
figure out how to write this expression to display the phone correctly?
Thank you for any assistance.