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

LeadingZeros: String(10-Len([FieldName]),"0") & [FieldName]
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"jkjmwilliams" wrote:

> 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

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 Removed)


"jkjmwilliams" <(E-Mail Removed)> wrote in message
news:3E4400A0-EEF2-40DD-ACDB-(E-Mail Removed)...
>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

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.

"Steve" wrote:

> 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 Removed)
>
>
> "jkjmwilliams" <(E-Mail Removed)> wrote in message
> news:3E4400A0-EEF2-40DD-ACDB-(E-Mail Removed)...
> >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
>
>
> .
>