Dear saigonf7q5- (name?)
You can affect the *display* of the numbers by applying a Format to the
field's definition. If your field contains 9 numbers, use:
000000000
.. As the Format property. That will display the leading zero.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: saigonf7q5 <saigonf7q5@yahoo.com>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Tuesday, October 30, 2012 8:29 PM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Retaining leading zero in number
I have a table that has a list of numbers. The data type of this column is
TEXT, and some of the rows (numbers) contain leading zero. e.g. 012345678,
023456789... This column is going to be linked to a column in a link table
which is also contains the same information (numbers) but in NUMBER data
type, but the numbers are without leading zero.e.g. 12345678, 23456789...
In order for me to link the 2 tables, I changed the data type of the first
table from TEXT to NUMBER, as a result the leading zeros are gone.
How can I keep the leading zero?
How do I retain leading zero in number
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar