Two Tables need same Data Type

A

Allison

I have two different ODBC tables and as a result of a make
table query I'm trying to change the Data Type on both
tables to read "text". One table already reads "text" but
the other reads "number" every time I try to change it the
change will not save??(Ms Access allows me to change it
but it will not keep the change). How can I change the
Data Type to "text" in the one and it to remain a text
field. (Keep in mind the information changes because the
fields are updated daily but as a result of the make table
query I was under the impression that I could make changes
to my table as needed regardless to the daily updates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Append Crosstab Query to Existing Table 0
How to have two tables on same line? 1
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Linking data in MS Word into Excel 5
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Word 2016 - Difficulties Learning Style Creation/Application 0

Top