Connecting Tech Pros Worldwide Help | Site Map

leading zeroes

  #1  
Old November 12th, 2005, 09:26 PM
jeff
Guest
 
Posts: n/a
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
  #2  
Old November 12th, 2005, 09:26 PM
Clive Moss
Guest
 
Posts: n/a

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Leading Zeroes in ZIP Code DanCole42 answers 2 July 25th, 2008 03:45 PM
Date changes and leading zeroes jbaranski answers 9 December 7th, 2007 10:02 PM
Using ToString to pad an integer with leading zeroes stainless answers 8 June 27th, 2007 02:05 PM
csv and leading zeroes Mike P answers 1 October 4th, 2006 04:15 PM
How to trim leading zeroes when converting decimal() to char() Jean-michel answers 1 November 12th, 2005 06:25 AM