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 to enter zip starting with 0 (zero) 10
Format Zip Codes Correctly for a Mailmerge 3
zip codes starting with 0 1
Leading 0 in Mail Merge document 4
How do you print leading zeroes in a zip code 2
Counting records in group in Details view 4
Printing zip codes that start with 0 2

Top