Changing table properties with VBA

[Mearntain]

Ive got 4 tables with on field name MO_ID that is formatted as a number. I then have a make table/append query that takes these 4 tables and puts them all into one table. At this step, I need to convert the field MO_ID to being a text field so that I can use an update query to change some special scan codes into word equivalents. For example, 100066 is getting updated to "Admin".

The simple solution would seem to be to change the the original 4 table fields to a text, but that wont work in this case. I have several other queries that need to have relational properties with other tables that comparing numbers to numbers so that wont work.

Is there a way to make that field change to a text field? But only when I run a certain query and only in that one table? Thanks and hopefully I made this clear .

[Homegrownandy]

I don't know the answer to what you ask, But it doesn't seem like a good solution.

[ItsMe]

I am sure you could make design changes to the table via DAO and the TableDefs collection. However, I would reconsider the overall design. I like to think outside the box for solutions. Sometimes, when you find yourself spending a lot of time looking for an additional solution, you went down the wrong path when you first deviated from conventional approaches.

[Mearntain]

I solved my issue by replacing the make table query with a delete query. I created the table with the desired field types ( rather than using a query to make the table), and just made a query to delete all the results in the table, and then fill them back in using an append query. Thanks to you two.