Tags: access, database, enter, microsoft, mysql, number, numbers, oracle, phone, single, sql, table, telephone
telephone numbers?
On Database » Microsoft Access
711 words with 3 Comments; publish: Wed, 05 Dec 2007 00:58:00 GMT; (25078.13, « »)
how do i enter a phone number into an access table as i have tried it and it keeps on taking the 0 off the start of the number
i have tried single and double aswell as interger none of this works
http://ms-access.itags.org/q_ms-access-database_185924.html
All Comments
Leave a comment...
- 3 Comments
- === Original Words ===
mitty
how do i enter a phone number into an access table as i have tried it and it keeps on taking the 0 off the start of the number
i have tried single and double aswell as interger none of this works
Use string type instead.
Tip
As long as you don't make calculations with a field, then set it to String
:cool:
#1; Tue, 11 Dec 2007 20:00:00 GMT
- ta m8 ill give it a go#2; Tue, 11 Dec 2007 20:01:00 GMT
- Alternately, you can implement a character mask to add a zero if one isn't present.
0-###-###-####
#3; Tue, 11 Dec 2007 20:02:00 GMT