Is there a way to define the Field Size and Data Type in the query when performing a Make Table?
I've tried Setting the field size and data type in an "existing" table and then use an append query to fill it, however, I receive a validation rule error.
I can make the table and then change the field size and data types for all of the fields without losing any data....
>>>>>> I need to give this file to someone every month, so a more automated way would be much appreciated!
Thanks in advance for any help!
I've tried Setting the field size and data type in an "existing" table and then use an append query to fill it, however, I receive a validation rule error.
I can make the table and then change the field size and data types for all of the fields without losing any data....
>>>>>> I need to give this file to someone every month, so a more automated way would be much appreciated!
Thanks in advance for any help!