DATABASE

[JULIE]

When preparing an overall data base to use on merged
files, if I type in a zip code that begins with "0" (ie,
02130) it drops the first "0." This only happens if the
zip code "begins" with zero. All other zeros don't get
dropped. "0" appears when typing it, but disappears when
I move on to the next field. Any clue what's happening
and how to correct it?

 

[NobodyMan]

When preparing an overall data base to use on merged
files, if I type in a zip code that begins with "0" (ie,
02130) it drops the first "0." This only happens if the
zip code "begins" with zero. All other zeros don't get
dropped. "0" appears when typing it, but disappears when
I move on to the next field. Any clue what's happening
and how to correct it?

Here's the best clue you'll probably get: Find out what database
program you are using (we don't know and can't read your mind). Find
a newgroup that pertains to THAT program. Go there and ask. You'll
get more help.

That said, you probably set up a number field for zip codes instead of
a text field. In Access (if you use Access, but you didn't say) that
will drop any leading zeros. If you MUST have them, then you'll need
a TEXT field, bur formatted to only accept digits.

If you don't know what I'm talking about, you need to do some serious
reading on database design and field setups. This isn't real hard and
if it's causing you problems, I can only imagine what will happen when
you get into more advanced areas with query and/or report generation
and, god forbid, macros.

 

[Bruce Chambers]

Greetings --

Set the properties of the zip code field to treat all entries as
text, rather than as numbers. For specific guidance, read the Help
files and/or manual that came with whatever database application
you're using.

Bruce Chambers

--
Help us help you:



You can have peace. Or you can have freedom. Don't ever count on
having both at once. -- RAH