Make Table Query...change data types

  • Thread starter Thread starter Lynn Pennington
  • Start date Start date
L

Lynn Pennington

When I make a table the field types are only text or
number.

Is there a way to change the data type? I have a field
coming in as a text type would like to change to a number.

Also - I have a text field coming in with a size 255 - I
would like to have that to size 14.

Any ideas?

Thanks,
Lynn Pennington
 
When I make a table the field types are only text or
number.
Click to expand...

Why are you doing MakeTable queries AT ALL? In my experience they are
very rarely necessary. Consider having an existing empty table with
the desired field types and running an Append query instead.
Is there a way to change the data type? I have a field
coming in as a text type would like to change to a number.
Click to expand...

You can use a calculated field Val([textfield]) to convert the text to
a number, and use that field in your maketable/append.
Also - I have a text field coming in with a size 255 - I
would like to have that to size 14.
Click to expand...

I don't think you can, but since Access trims trailing blanks, it
makes very little difference: a 14-byte string takes up only 14 bytes
on disk, whether the field is 14 or 255.
 
Back
Top