how do I stop Access from dropping 0 on zip codes starting w/0?

G

gigi

I'm running reports in Access from an Excel database which includes zip codes
starting with 0. Access drops of the 0 because it's in the first position.
If I change the zip code to text in Excel, then Access doesn't show the entry
at all. How do I get a zip starting with 0 to show in Access (Example 03492).
Thanks
 
S

Stefan Hoffmann

hi Gigi,
I'm running reports in Access from an Excel database which includes zip codes
starting with 0. Access drops of the 0 because it's in the first position.
If I change the zip code to text in Excel, then Access doesn't show the entry
at all. How do I get a zip starting with 0 to show in Access (Example 03492).
Click to expand...
You need to store the zip in a TEXT field, not as number, e.g. LONG INTEGER.



mfG
--> stefan <--
 

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

Similar Threads

Split a string in one field into two fields 4
How do I set focus (and select text) on a text box on a modeless userform? 0
How to enter zip starting with 0 (zero) 11
How do I not drop the leading 0 in a zip code mail merge? 2
Format Zip Codes Correctly for a Mailmerge 3
Format Zip Codes in Excel for a Mailmerge 2
Leading 0 in Mail Merge document 5
Insert Zip codes into weather code 5

Top