Format in make table query

[belsha]

I have data coming from a table using an input mask for the social security number. It then goes into a query and is formatted perfectly in that query as a select query. I then change it to a make table query and have it make a table outside the current database, and in that new table the formatting is lost. I have tried formatting the query results with an input mask, that didn't work. I know I can format the table field after it is created, but since this table is created and destroyed often, I would just like it to come over correctly from the make table query. Any suggestions would be appreciated!

 

[belsha]

I need to use the make table queries as I am making another database from the one I am generating the queries from. Is there any way at all to get the formatting to go thru to the new tables using a make table query? What syntax would I use specifically in the query to format the SSN? Thanks.

 

[belsha]

I created another table with the formatting I wanted for the fields in that, then used an append query to bring in the information. That worked fine.