| | |
|
|
|
Left zero fill on export of field |
|---|
| message from jubejoie@aol.com on 11 May 2004 |
I see on my table the left zero fill in a field defined as
number 5 in length and format = 00000. When data entering
a 1 in this field the table will look like this "00001",
WHICH IS WHAT I WANT. But when I export the table, fixed
length , the leading left zeros disapear!
How do I get my zeros to come export out!?
thanks
|
| Allen Browne replied to jubejoie@aol.com on 11 May 2004 |
1. Create a query.
Format([MyField], "00000")
where "MyField" represents the name of your field.
3. Export the query.
|
| Terry Kreft replied to Allen Browne on 12 May 2004 |
LOL, synchronisity.
|
| Allen Browne replied to Terry Kreft on 12 May 2004 |
We've both been doing this too long, Terry! :-)
|
| =?Utf-8?B?UGFuZ28=?= replied to Terry Kreft on 12 May 2004 |
You can opt by saving the format on the save dialog box. After you chose the format to export to and the file name, you can also choose to keep the actual format.
Pango
|
| Terry Kreft replied to jubejoie@aol.com on 11 May 2004 |
1) Create a query based on the table
2) In the query grid, in place of the field you want formatting put
Format([YourFieldNameHere], "00000")
3) Save the query
4) Export the query
|
| =?Utf-8?B?UGFuZ28=?= replied to jubejoie@aol.com on 12 May 2004 |
You can opt by saving the format on the save dialog box. After you chose the format to export to and the file name, you can also choose to keep the actual format.
Pango
|
|
Archived message: Left zero fill on export of field (Microsoft Access)
