10 digit numbers

J

jkjmwilliams

I have a number that will be pulled up in a query that I would like to be 10
digits, with the leading black places as zeros. How do I get the zeros in
there?
JoAnn
 
S

Steve

There are NO NUMBERS that begin with 0!!! All you can get is a 10 character
yext string that contains only numeric characters. That's what Jerry is
showing you.

Steve
(e-mail address removed)
 
J

jkjmwilliams

Thanks Steve for the tip about numbers and strings. Yes, I had the field
saved as a number. Changed it to text and things worked a lot better.

Thanks Jerry for the SQL statement. It worked great after I changed my field
to text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restore leading zero 3
validation rule for exactly 5 digits, including leading zeros 0
Adding in leading zeros and a space to a text field in a table 4
Leading Zeros 7
Export of text field trims leading zeros 1
Access 2003 - Joining number and text data 3
LEADING ZEROS 7
Number isssue 11

Top