Access and rounding 1

[Thant]

Greetings,
I am getting very frustrated by what is probably a simple problem. I have tried various ways to get my columns to display percentages correctly but I can never make it happen. I have a column called % change from last year. It should show a number like 11.85% but instead when I put a number in this field it not only does not display correctly it keeps rounding my field up to 12. I am not a visual basic person so im not sure if I can fix it there but I have played with almost every permutation of the field values I can think of and cannot get this to work correctly.
Any advice would be great!
Thanks in advance

 

[SkipVought]

What is the field FORMAT and Dcimal Places set to in the Table Design?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Thant]

it is setup as Number,Integer and 2 decimal places. There is no format. I have tried the percentage format but it keeps adding too many decimal places
Thanks

 

[SkipVought]

Number,Integer and 2 decimal Places

That's like requesting dry water!!!

An INTEGER is, well, er, an INTEGER. It CANNOT have decimal places!

I have tried the percentage format but it keeps adding too many decimal places

EXACTLY WHAT did your try? Did you try the PERCENT format with DECIMAL PLACES set to 2?


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Thant]

Yes I input 20.60% and it comes out 2060.00%
Thanks

 

[SkipVought]

If you enter 20.6 the percent value is 2060%.

However, if you enter .206, the percent value is 20.6%.

1 is 100%!!!


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Thant]

That worked thanks for your help. Apparently I am suffering from a lack of coffee today!

Thanks

 

[SkipVought]

I still have half a pot left.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]