We have many people within one town with a zip code beginning with zero. We
can put in the Town, the State abbrviation, but can only create a field to
accept the last 4 digits (non-zeroes) in the field we are using for a zip
code. Any ideas?

Numbers simply don't have leading zeros. Change the field from Numeric to
Text.

Unless you are planning on doing math functions (addition, subtraction,
multiplication) with your zipcode field, you won't be losing anything.

HTH,

"Rural Land Trust" <Rural Land (E-Mail Removed)> wrote in
message news:BD97F029-96E7-4FA3-9CDA-(E-Mail Removed)...
> We have many people within one town with a zip code beginning with zero.
> We
> can put in the Town, the State abbrviation, but can only create a field to
> accept the last 4 digits (non-zeroes) in the field we are using for a zip
> code. Any ideas?
>

Make sure your zip code field is text in the table design instead of number.

"Rural Land Trust" wrote:

> We have many people within one town with a zip code beginning with zero. We
> can put in the Town, the State abbrviation, but can only create a field to
> accept the last 4 digits (non-zeroes) in the field we are using for a zip
> code. Any ideas?
>

Rural Land Trust wrote:
> We have many people within one town with a zip code beginning with
> zero. We can put in the Town, the State abbrviation, but can only
> create a field to accept the last 4 digits (non-zeroes) in the field
> we are using for a zip code. Any ideas?

Postal codes are not number, they are characters. Don't use a number
field. Also remember that if you have any international addresses you are
going to need to have letters as well as numbers.

--
Joseph Meehan

Dia 's Muire duit