unwanted text added to field - heeeeeelp!

[Nate]

I had some wonderful help figuring out how to change the report source from
a table, to a query, and it works great except for one problem. One of the
things I do from the data base is making address labels. Unfortunately, I
have alot of problems getting the other program I am using to accept Access
db's as is. I've found that the solution to this is to export the the report
to Excel and then use the Excel file in the other program. Up until now, it
has worked fine. When I try it now with the report coming from the query
rather than table, the labeling program treats the "zip code" field as a
numeric field. What happens is that a decimal point is placed after the 4th
digit of the code, and any codes that start with "0", the digits are
canceled out.

Here's the examples
1054.9 vs 10549
2021 vs 02021

 

[Nate]

I should add to this that I tried creating a report using all but the zip
code, exporting that to Excel, and then addig the zip code field and the
values, and the label program couldn't read the field. I should also add the
following: Using the old method, creating a report from an Access Db table,
rather than a query, and then exporting that to Excel, works fine. This
tells me that the source of query vs table is the problem.