Query to add a zero.

J

joey

If you reimport the information again set the table up so
that the table for the zip is a "double" and the format
is "fixed" this will allow the 0's to show up. If you
can't import make a new column in the query with 0's only
in it. Insert another column with this formula [Any Name]:
[Namw of zero column]&[name of zip code column] this
should do the trick!
Hope that helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top