Creating a query in MS Access 2003 that converts text data to numeric from a table that has links to it. I have an idea on how to convert the text data to numeric. The problem is that I want to take text data from one table then temporarily create another table where the converted data will be stored. The table that contains the text data and is linked. How do I do this?