Too many decimal

[Dano60]

Hi,

I did an append query that make a division on a number in the table and overthought the decimal is set to 2 in the changing field, the equation return more decimal than 2.

[aytee111]

Set the number of decimals when you display the field to the users, never on tables. Leave the number of decimals on the table as Auto, when you need to display the field use the Format function.

[Dano60]

Hi,

Very new to this Access thing.

Can you please elaborate!!!!!

[ranman256]

if you store data in a Currency field, it will only allow 4 decimals. (you can turn off the $ sign)

[aytee111]

Keep the properties of each field in table design sacrosanct, no formatting or lookups or anything that is added to plain data. Then whenever you want to display it use the format command, either in a query, form or report.

[pbaldy]

You can use the Round() function around your calculation to limit the result to 2 digits.

[Dano60]

You can use the Round() function around your calculation to limit the result to 2 digits.

In that formula where would the round function go?

IIF([Reliure_grosseur]=8;[quantiteSpirale]*((35*0.000957)/25);Switch([Reliure_grosseur]=10;[quantiteSpirale]*((35*0.001381)/25);[Reliure_grosseur]=11;[quantiteSpirale]*((35*0.00156)/25);[Reliure_grosseur]=12;[quantiteSpirale]*((35*0.00162)/25);[Reliure_grosseur]=14;[quantiteSpirale]*((35*0.001757)/25);[Reliure_grosseur]=17;[quantiteSpirale]*((35*0.002004)/25)))

[pbaldy]

Ugg, I don't care for that hard-coded logic, but the function goes around each calculation, like:

Round([quantiteSpirale]*((35*0.000957)/25), 2)

[Dano60]

Thank you very much worked perfectly!!!!!

[pbaldy]

Happy to help!