Format field in query to export to fixed field text file.

[cav]

I need to export field a phone field from a query as fixed field text file. How do I make it a 12 character phone field that will export with the format 999 999-9999. Even though it shows up fine in the query, even if I put a mask on it and say to store with space and dash, it reverts in the export to 10 digits removing the space and dash. Is there a way to do this without programming such as through the format property?
I appreciate any help...IMMEDIATELY. Thanks.

 

[RoyVidar]

Hi!
Try

"Expression: mid([yourphoneno],1,3)&" "& mid([yourphoneno],4,3) & "-" & mid([yourphoneno],7,4)"

in the "Field"-field in your query.

Roy-Vidar