Scientific data suddenly rounding up

L

Liz

I have been inputing data in a database for a while and suddenly my
scientific data is rounding up. The rest of the data hasn't been affected
though. I made sure the data type was set to Scientific when I developed the
database. I also have it set so the database can take up to 15 characters
before or after the decimal. (Example of what's happening: 8.86E+06 turns
into 8.80E+06). I checked out the tables thinking it may have been a glich in
the form, but I can't input the right numbers in the tables either.

I checked out the other posts, but no other post dealt with rounding
scientific data.
 
A

Allen Browne

Open your table in design view, and select this field.
What is the Data type?
In the lower pane, what is the Field Size?
 
L

Liz

Dear Allen,

I wrote in my previous post that the data type is Scientific. The field
size is Decimal. And the Precision is 18. The scale is 0 and the Decimal
Places are set to Auto.
 
A

Allen Browne

Hi Liz

If the data type is Scientific, then I guess this is a linked table from a
different type of database. Access doesn't have that type.

If it is an Number field in an Access table, of size Decimal, then anything
is possible. The are bugs and inconsistencies with this data type.

In a quick test, I was not able to reproduce your issue. However, you did
say that it developed the problem after you had been inputting, so maybe it
did not show up straight away.

I tried creating a field of type Number, size Decimal, format Scientific,
precision 18, scale 0, decimal places 0, unindexed. Entered 8860000, and it
displayed as 8.86E+06.

Note that the Scientific data type does *display* 1 digit before the decimal
place and 2 afterwards if you leave the Decimal Places property as Auto.
That is the behavior of the Scientific format with all the Number types in
Access. If it is this format that is the problem, you could specify your
own, such as:
0.0################E+00

It that's not the issue, it would be worth elimating the ususal suspects:
Name AutoCorrect, corrupted index, etc.

HTH
 
L

Liz

Dear Allen,

Sorry, but the information that you tried to help me with didn't help. I
however found a solution. The reason I never had a problem before and
received it after I have been imputing data for a while is because I had to
run a repair on the database. The way you can do this is by going to the
toolbar, selecting Tools>Database Utilities>Compact and Repair Database. Now,
it's running smoothly again.
It wasn't a different database, it has always been an Access database to
answer your question from your previous post. Also, I meant that the data
type I was working with was Scientific, which is essentially the "format" I
chose. Sorry that I didn't communicate that more clearly to you. Thanks for
trying to help.

Liz
 
Top