I have a field with 14 digit numbers. I am trying to do a Make Table query, and keep the same field format in ACCESS 97
Field Size: Double
Format: Fixed
Decimal Places: 0
Even though this is the original field, format, when I do the make table, it defaults to
Field Size: Double
Format:
Decimal Places: Auto
How can I get it to keep the same basic format?
Thanks
Field Size: Double
Format: Fixed
Decimal Places: 0
Even though this is the original field, format, when I do the make table, it defaults to
Field Size: Double
Format:
Decimal Places: Auto
How can I get it to keep the same basic format?
Thanks