Results 1 to 3 of 3

Thread: freaking zeros

  1. #1
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122

    Unanswered: freaking zeros

    I have a table with a zip code field some of the zip codes start with zeros. i export this to excell and it leaves the zeros off. How can i change the format in Access to include the Zeros. If i change it to text- it works but i have to go and add all the zeros to the zipcodes that are missing the zeros- is there an some knid of format i can run that will change my zipcodes to a five digit number (adding zeros where it needs to)

  2. #2
    Join Date
    Dec 2003
    Posts
    268

    cut and Paste or Export

    Are you cutting and pasting or are you exporting the query from Access into Excel? I think if you export it, the format of the text will be propogated into Excel.

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    0's

    If you're exporting, in your export query (make a query) enter for the field:

    XXX: int([FieldName])

    or

    XXX: chr([FieldName])

    Otherwise I haven't found a way to do it with exporting a table other than through code.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •