decimal places

[Burnsie]

Hello.

I have a table that is displayed as a sub form of a main form (ie main form is cleint details, the subform are the results from a medical test)

Anyhow, some of the data (medical tests) in this table requires a number to be recorded with 2 decimal places. This has been set as such in the table design view. However, when I enter the testing data results in the table the data automatically defaults to 0 decimal places, rounding up/down numbers.

Any idea why this is happening. Is it because I already had some table data in before realising and changing the decimal places to 2 decimal places??

 

[JHB]

Look at the field type/size in the table, it has to be a type which can hold decimal data.

 

[Burnsie]

Look at the field type/size in the table, it has to be a type which can hold decimal data.

The data type is "number", field type is "long Integer" and decimal places set to 2

 

[pr2-eugin]

Long Integer means only Whole numbers or no fraction or decimal numbers. Change the Number type to Double or Single.

Integer => 5
Double => 5.5689854223

 

[Burnsie]

Long Integer means only Whole numbers or no fraction or decimal numbers. Change the Number type to Double or Single.

Integer => 5
Double => 5.5689854223

thats got it, thanks

 

[JHB]

As I said.