I need to automate changing the properties of fields in a table created with a Make Table Query. The fields are created as "Text" fields. They are numeric fields that have to be used in equations later on. I need to change them from "Text" to "Number". I tried a macro with "SendKeys" but it will not work. I also tried to write a function that formats them, but this will not work on a table. I need to automate this a the database is for users who will probably hose it if I let them change table designs.
Thanks so much.
Thanks so much.