Access add zero's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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.
 
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!
 
Decimal types tend to be buggy, so I'd be looking at the data type,
but the first thing I would check would be the decimal separator
settings in your pc's 'regional options'

(david)

Rutger said:
Hi!

Reinstalled Windows XP frpm scratch and discovered that when dealing with
Click to expand...
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?
 
Back
Top