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
|
|||
|
|||
Leading Zeros
I am running Access 2003 and importing data from Excel 2003.
One field has a six digit film number and some of these numbers have leading zeros. I can not get Access to maintain the leading zeros in the field or to show them on a report. How do I get Access to show these leading zeros. Larry |
#2
|
|||
|
|||
"Lawrence E. Oliver" wrote in message
... I am running Access 2003 and importing data from Excel 2003. One field has a six digit film number and some of these numbers have leading zeros. I can not get Access to maintain the leading zeros in the field or to show them on a report. How do I get Access to show these leading zeros. Either use a Text DataType instead of Number or set the Format property on your forms and reports to "00000" (using the number of zeros appropriate to your purpose). If you want to simultaneously see records like 0123 and 45 then you have to use a Text DataType. A Format property will want to force the same length for all records padding as many zeros as it takes to achieve that. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Thanks -
Larry "Rick Brandt" wrote in message . .. "Lawrence E. Oliver" wrote in message ... I am running Access 2003 and importing data from Excel 2003. One field has a six digit film number and some of these numbers have leading zeros. I can not get Access to maintain the leading zeros in the field or to show them on a report. How do I get Access to show these leading zeros. Either use a Text DataType instead of Number or set the Format property on your forms and reports to "00000" (using the number of zeros appropriate to your purpose). If you want to simultaneously see records like 0123 and 45 then you have to use a Text DataType. A Format property will want to force the same length for all records padding as many zeros as it takes to achieve that. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Crystal Reports Export to Excel - Retaining Leading Zeros | CR-Tech | General Discussion | 1 | November 1st, 2004 06:15 PM |
Linked Table field...strip off leading zeros of text | Inyo55 | Database Design | 1 | July 24th, 2004 01:11 AM |
Number with leading zeros | SteveM | Worksheet Functions | 3 | February 2nd, 2004 04:47 PM |
Leading Zero's | Tami | Worksheet Functions | 2 | November 24th, 2003 03:27 PM |