I looked around on the forums and I found a 7 month old tread, however the solution was not what I needed. I tried to make a query on an table that has a field that is Text(that has numbers only) and in a different table is a field that is Number, how do I fix this. I get the error type mismatch, which makes sense now, however I did not know that this would hurt me down the road. I made the first table back in 2014 as I was learning access, and now I see the issue, however I have never found a work around or fix the table without data loss, now the table that has this text field has over 20K records. I just manually copy all data to Excel and resolve this problem once a month. I know there is a better way.