Keeping Zeros

[Guest]

How do I keep to zero in front of a figure, eg 012345 in Access?

 

[Guest]

Hi Vanessa

The mad Romans came up with the "idea" of 0 in the 1st century AD and since
then it has caused problems.

A number is 1234
A number is not 0001234 as a number as is (to put in simply) just a count of
items.

So to "see" the leading zeros you want you will need to make the field a
"text".

Open the table in design view an change the format.

Note - only do this if it is really important as you can not use text fields
in formulas (1+1=2 but ABC+1=Error) well you can but you then need to
"extract" the number section of the field which is a real pain.

Hope this helps

 

[Graham Mandeno]

Hi Vanessa

A computer can't tell the difference between the number 42 and the number
000042. In both cases, what the computer *stores* is something that is
better represented by 101010.

You are not really concerned about the way the number is *stored*, but the
way it is *displayed*.

So, how many zeroes do you want? Do you always want to see (at least) six
digits, so that 12345 looks like 012345, and 42 looks like 000042?

Then set the Format property of the textbox on your form or report where the
number is displayed to:
000000

If you need something different then post back for more help

 

[Terry Kreft]

That's wrong, if it were true why is there no roman numeral for 0?

http://home.ubalt.edu/ntsbarsh/zero/ZERO.HTM

.... which is a bit long but a bite size version could be
http://www.mathmojo.com/interestinglessons/originofzero/originofzero.html

 

[Guest]

Ha Ha Ha you’re almost certainly right that I am wrong, BUT my teachers at
school were adamant that almost everything was invented by the Romans and as
I went to school in Northern Italy you will understand why. So I freely
admit that you could be right but on the other hand I’m still sure that the
Romans really did invent the television, the felt tip pen, atomic power and
mobile cell phone although I must also admit that they probably never came up
with a good answer to making custard without the lumps.

 

[Brendan Reynolds]

My teachers claimed that the Romans learned everything that they knew from
the Greeks, but then that's probably because I did *not* go to school in
Italy!

According to this article, zero was invented in India ...

http://en.wikipedia.org/wiki/Zero

 

[Guest]

Ha Ha - since writing that rather over partiisan post I have come to realise
that my teachers may have be also slight over partisan