How not to have zero suppression on table number field?

D

DeniseB

I want to create a table with a numeric field and make it so it does not zero
suppress the number. I.E. want to enter 001 or 012 or 009. In other words,
the field must me length of 3 and numeric.
 
R

Rick B

To do that, you would need to make it a text field.

You could DISPLAY them with the extra zeros by using a format in your
tables, forms, etc.

"Numbers" don't have leading zeros. You don't have "zero zero one dollar"
you have "one dollar".

Hope that helps.
 
C

Chriske911

I want to create a table with a numeric field and make it so it does not zero
suppress the number. I.E. want to enter 001 or 012 or 009. In other words,
the field must me length of 3 and numeric.

if it is a number field just use the format for that field and set it
to 000

grtz
 
D

DeniseB

I did the format and it does work. The problem comes in when the table is
saved. Ultimately, I want it saved as 001 so I can export it to a comma
delimited file and have the field value be 001 not 1 and it has to be numeric.
 
C

Chriske911

I did the format and it does work. The problem comes in when the table is
saved. Ultimately, I want it saved as 001 so I can export it to a comma
delimited file and have the field value be 001 not 1 and it has to be
numeric.

how do you export the data?

code,
transfertext,
query
....

grtz
 
D

DeniseB

I did format it as 000.
But it saves it as 1 and not 001
I do a File, Export and also tried it by using a Macro and selected comma
delimited format. when I opened the file in Wordpad, the field was saved as 1
and not 001.

I need this because I am sendint the comma delimited file to a vendor and
they need that field to be 3 digits long and numeric.
 
Top