Re: how to gain numbers
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 16 Aug 2007 22:38:30 -0600
On Thu, 16 Aug 2007 17:44:32 -0700, Naveed Pathan
<NaveedPathan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
thanks for the response
dear friends i do know to use Text data type instead of number data type if
i am not using that field for calculation but dear friends i am using the
field for numbers + i need to retrieve the serial of a specific data.
like i have mentioned earlier.
Open the table in design view.
Select this field.
In the second column of the design grid, next to the name, you can select the
datatype - text, number, date/time, etc. Select Text.
"5" and "9" and "0" are characters as well as being numbers, you can simply
store an eight-character long text string which consists only of numeric
characters. This can be sorted, searched, retrieved, printed - it even is
*better* than a Number field in that you can store leading zeros.
John W. Vinson [MVP]
.
- Prev by Date: Re: Yes/No field showing as 0 -1
- Next by Date: Re: Error 3125 doesn't apply here. So, what's the problem.
- Previous by thread: Re: how to gain numbers
- Next by thread: Re: how to gain numbers
- Index(es):
Relevant Pages
|
