Connecting Tech Pros Worldwide Forums | Help | Site Map

leading zeroes

jeff
Guest
 
Posts: n/a
#1: Nov 12 '05
When I import a file from Excel that is a label with numbers starting
with a zero such as 0474, the zero is dropped off when I produce the
access report. How can I get it to remain?

Jeff

Clive Moss
Guest
 
Posts: n/a
#2: Nov 12 '05

re: leading zeroes



"jeff" <jeff@sattutor.com> wrote in message
news:c7307e88.0403071506.17b5b1fa@posting.google.c om...[color=blue]
> When I import a file from Excel that is a label with numbers starting
> with a zero such as 0474, the zero is dropped off when I produce the
> access report. How can I get it to remain?
>
> Jeff[/color]

Set the Access field type to text

Clive


Closed Thread