Missing Zeros

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I receive batch files in the form of csv files and process them in Access.
In the zip code fields that should that start with a zero the zero is always
missing. Is there a way to run a query on the zip code field to check for 5
characters and ad a zero where only 4 are present?

Any help is appreciated

MS Office 2000

Tim


.

Relevant Pages

  • Re: Missing Zeros
    ... Then build a query with a new column like... ... > I receive batch files in the form of csv files and process them in Access. ... > In the zip code fields that should that start with a zero the zero is ...
    (microsoft.public.access.queries)
  • Zeros in empty merge fields
    ... have two zip code fields: one for physical address and one ... I tried setting the options by unchecking zero, ... but that doesn't fix the problem. ... just disappear as do other empty fields. ...
    (microsoft.public.excel.misc)