Help

[Guest]

I have a table that has two fields in it...

JobClassID -> Primary Key -> Number
JobClassDEscription -> Text

Here are some of the Records I have in this table....

JobClassID JobClassDescription

1 Office Staff
14 Welder
100 Greaser
140 Operator
Etc Etc Etc...

The first two job classes in my table "1" and "14" should have really be
"001" and "014". Since this is a number data type access always drops the
leading zeros when I put them in. It is very important for them to be
displayed as 001 and 014 instead of what currently gets stored 1 and 14. Is
this possible when the data type is numeric. If the field gets changed to
text can it still be joined with a relationship 1 to many? Is there anything
I can change or program so that the leading zeros will stay present in a
numeric field? any help or advice would be greatly appreciated.

Thanks in advance

 

[Guest]

In you table design view, for your JobClassID field, change its format from
whatever you have (e.g. Standard, Fixed) to just 000. This way your values
will appear as 014,001,191, etc. If your class Id can go above 999, just add
another 0

 

[Mark]

Change the data type to Text and make the size however many characters your
ID field could be (3,4,9, etc.). As long as each foreign key field in
related tables have the same data type and size, it doesn't matter what they
are; integer, text, etc. you should have no problem relating tables to each
other.