New to Access, simple question

[Railsplitter44]

I have an access database which I have imported all information from an excel spreadsheet. The values in Access are the results of complex formulas and have resulted in values with many numbers after the decimal point (ie 1.593874522 etc). I have formated these values to 2 decimal points (ie 1.59) but when formatting a number, it just changes how that number appears.

Is there a way to remove the extra decimal points entirely? I understand that this will change the value entirely, but I want the actual value to reflect the number format.

Is there any way to do this?

Thank you very much for your help

 

[Brianwarnock]

You can Round a number to as few decimal places as you wish, see Help.
Actually its just Round([fieldname],number decimal places)

Brian

 

[Railsplitter44]

I could be wrong, but I think that you may be misunderstanding my question. I want to physically remove the extra decimal points from the actual value in the cell. So let's say that the original value in the cell was 2.5142987. I want to change it so that not only does it appear to be 2.51 but when you click on the cell the actual value inside of it is 2.51 and the 42987 have been completely removed.

 

[Brianwarnock]

That is what round does, you could update the field in the table to Round(fldname,2) and lose the rest of the decimal points forever.

Brian

 

[durexlw]

Isn't it so that if you specify on your table properties you only want two decimals, it get's rounded automatically.

As said in the initial post, formatting only handles how it appears, but specifying the number of decimals in your table properties should fix that too if you ask me.

 

[Brianwarnock]

Nope, that's only a format.
do a test say that you want fixed 2 decimal places but type in 3.
sure it shows 2, but in a query say round(fld, 3) and it will show the third.


brian