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!
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!