formatting help

[mpsamuels01]

Hey I was wondering can I get a little help in the custom formatting
section. I have table full of 6 digit numbers but when there are
0(zeros) involved access ignores them and screws up everything. The
problem is the zeros are not always in the same place I have numbers
like 214000 or 214020 or 214007 and the results are 214 or 21420 or
2147. How can I fix this. Those zeros are there when imported but are
still ignored.

 

[Rick B]

I have never seen a field delete zeros unless they are in the left position
which is normal for a number. 00123 and 123 are, of course, the same thing.

You say the zeros are there when imported (meaning they appear in the
table?) but are still ignored. What do you mean they are IGNORED?

Rick B

 

[Joseph Meehan]

Hey I was wondering can I get a little help in the custom formatting
section. I have table full of 6 digit numbers but when there are
0(zeros) involved access ignores them and screws up everything. The
problem is the zeros are not always in the same place I have numbers
like 214000 or 214020 or 214007 and the results are 214 or 21420 or
2147. How can I fix this. Those zeros are there when imported but are
still ignored.

Keep in mind that a number has no leading zeros. A number may be
displayed with leading zeros or the characters 0123456789 may all appear in
a text field where the zero is no different than an s or P. Of course you
can't calculate with text.

Access will always store "numbers" as numbers so they will not have
leading zeros. However you can chose to display numbers with leading zeros
using the formatting tools available in forms reports etc.

 

[mpsamuels01]

Hey guys thanks for your help but I think it might be an error on my
part from importing the data from excel. I will let you as soonas i
figure it out.