Hi all I have a table and the nu

[Sadukar]

Hi all

I have a table and the numbers are going in and automatically rounding off.
IE: If I enter 7.5 it will round up to eight. How do i turn this off.
The field properties are set to Long Integer with 2 decmil places.

I have messed around a bit but cant find what is wrong.

Thanks
S.

 

[willir]

Sadukar

The field is defined as an "Interger".

Change it to a "Single" to accept floating point decimals. (If single is insufficient, ie, you work with numbers in excess of –3.402823E38 to –1.401298E–45, use "Double".)

Richard

 

[Sadukar]

Thanks richard

It works if I put new values in but the old values stay the same. They will not change to the value I originally put in. IE 7.5

I know they still retain those values as I tried adding up a few in reports.

Any suggestions on how I can change them?

 

[willir]

Unfortunately, you are stuck with the original data.

An interger is an interger is an interger which means no decimals.

Access is very specific in how it stores data, and which data integrity rules to follow.

 

[Sadukar]

Thanks Willir

At least I know there is nothing I can do.

Also sorry about the subject. Just forgot.

 

[willir]

Sadukar

School of HardKnocks -- we all have been there. It is part of learning.

 

[tahilg]

I am not sure of this but can't you "recover" the decimal numbers by (a) downloading the data to say an Excel spreadsheet, (b) clearing out the Access table and (c) reloading the data. When you reload, the numbers will now be entered as Single instead of as Integer as they were previously.

Gunny

 

[Sadukar]

tried what you said.

It did re-enter as a double number but the numbers went back in as the rounded off numbers.

Thanks anyway.

 

[tahilg]

That puzzles me Sadukar. I suspect that when you downloaded it to Excel it also perhaps set the format of the cells or column(s) there to the original wrong format for those numbers. Perhaps after downloading you should redefine the format of the relevant column(s) to decimal numbers before reloading.

Gunny

 

[Sadukar]

tried
wont work.

Thnaks anyway.

 

[tahilg]

Hi Sadukar,

I just successfully closed and then re-opened a folder. The only thing I can think of is that perhaps you should have closed the folder before deleting its Outlook data file. Can you in anyway restore the file(s) you deleted?
If not, you might try creating appropriately named copies from existing Outlook data file(s), then closing the folder(s) and finally re-deleting the copies.

The only other thing I can recommend is that you do a "Detect and Repair..." (in Help menu). But I should caution you that that tends to reset a lot of your customisations and settings in all MS Office components.

Gunny