|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 27th, 2009, 02:48 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Auto fill in missing digits
I have a file I am importing into a table and if the number begins with one
or two 0's they are missing from the data in the new table. How can i set up the formatt on the table so the numbers are a set length and if not, it will automatically fill in the missing 0's? 
|
|
#2
August 27th, 2009, 04:18 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Auto fill in missing digits
On Aug 26, 8:48*pm, txlogic wrote:
I have a file I am importing into a table and if the number begins with one or two 0's they are missing from the data in the new table. *How can i set up the formatt on the table so the numbers are a set length and if not, it will automatically fill in the missing 0's? What is the data type of this field? If it's numeric, then you can't keep the leading zeros. If it's not a field that you do math on, it should probably be a text field anyway. You can use Format$() to do this.
|
|
#3
August 27th, 2009, 05:38 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Auto fill in missing digits
On Wed, 26 Aug 2009 18:48:03 -0700, txlogic
wrote: I have a file I am importing into a table and if the number begins with one or two 0's they are missing from the data in the new table. How can i set up the formatt on the table so the numbers are a set length and if not, it will automatically fill in the missing 0's? Use a Text field, not any sort of number. As numbers, 31 and 031 and 0000000000031 are just three different ways of depicting *exactly the same number*. -- John W. Vinson [MVP]
|
|
#4
August 27th, 2009, 03:21 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Auto fill in missing digits
For clarification, it is wrong to refer to 031 and 0000000000031 as numbers.
There are absolutely no numers that look like 031 and 0000000000031. Both 031 and 0000000000031 are character strings and therefore text data type. You are one-hundred percent correct in saying "Use a Text field". Steve "John W. Vinson" wrote in message ... On Wed, 26 Aug 2009 18:48:03 -0700, txlogic wrote: I have a file I am importing into a table and if the number begins with one or two 0's they are missing from the data in the new table. How can i set up the formatt on the table so the numbers are a set length and if not, it will automatically fill in the missing 0's? Use a Text field, not any sort of number. As numbers, 31 and 031 and 0000000000031 are just three different ways of depicting *exactly the same number*. -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
