Exporting Queries with Zip Code to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Currently I am working with a database that requires a form to export a set
of data run by a query to an xls table. this table contains information
regarding customers, such as their ZIP code. However, i find it very
difficult to keep the ZIP codes formatted correctly when the query is run.
it always seems to drop the leading zeros. i have inserted an input mask
into the source table, but that just leaves hyphens at the ends of all the 5
digit zip codes. this is OK, but i would prefer to only have the hyphens
where they are needed (9 digit zip codes). also, it seems to make little
difference what the format is when a query is run, as it seems to just see
them as numbers and drop all the excess. (leading zeros and hyphens!)

any help on how i could get the Zip codes to stay properly formatted when
they are exported (using and output to command) to Excel.
Thanks!
 
Nevermind, I realized that the whole reason my format was not working
correctly was because the query was referencing the wrong table....wow, what
a noob mistake.
 
Back
Top