Access add zero's

R

Rutger

Hi!

Reinstalled Windows XP frpm scratch and discovered that when dealing with very large numbers Access calculets wrong. Stating a queary involving eg 2 000 000 000, Access adds two zeros: 2 000 000 00000. Same problem with access 2000. Only seen this problem on Windows XP. Anyone seen this problem?

Any hints would be appreciated!
 
D

Damien McBain

Rutger said:
Hi!

Reinstalled Windows XP frpm scratch and discovered that when dealing
with very large numbers Access calculets wrong. Stating a queary
involving eg 2 000 000 000, Access adds two zeros: 2 000 000 00000.
Same problem with access 2000. Only seen this problem on Windows XP.
Anyone seen this problem?

Any hints would be appreciated!
Click to expand...

Where are the values that you are looking at (In a table or another object)?
What's the fieldsize property set to?
What's the format of the field?
Is it truncated because the column is too narrow in a datasheet view?
What happens when you perform a calc, does it use the real number or the
erronious one?

2 billion is NOT a "very large number". A "long interger can
be -2,147,483,648 to 2,147,483,647. A "single" can
be -34,028,230,000,000,000,000,000,000,000,000,000,000 to
34,028,230,000,000,000,000,000,000,000,000,000,000.
A "double" can be up to +or-
17,976,931,348,623,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0
00,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0
00,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0
00,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0
00,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,0
00,000,000,000

Your problem is most likely the way your data is being displayed IMHO.

Damo
 
D

Damien McBain

Hmm, Rutger, I think you will have to wait for one of the gods to reply
post. It appears unlikely to be db properties at fault. I would recommend a
sweep of Google also.
 
J

John Vinson

Hi!

Reinstalled Windows XP frpm scratch and discovered that when dealing with very large numbers Access calculets wrong. Stating a queary involving eg 2 000 000 000, Access adds two zeros: 2 000 000 00000. Same problem with access 2000. Only seen this problem on Windows XP. Anyone seen this problem?

Any hints would be appreciated!
Click to expand...

VERY odd; I've never seen this happen. Damien's question about
datatype and field size was the first thing I'd have asked too.

Note that Long Integers are limited as Damien says, and you're pushing
this size; Single numbers can be enormous but only allow some seven
decimal places accuracy, while Doubles allow some fourteen.

If you could also open the Query in SQL view and post the SQL text
here it might help figure out what's happening!
 
Top