Percentage Problem in Append Query

[csoseman]

I'm trying to append a query that calculates percentages append that query to a table. When I open the table the percentages either show up as 0% or 100%. I have set the field in the query to percentage and the corresponding field in the table to long integer/percentage and still can't get it to work. Any ideas?

 

[CBrighton]

Long integer doesn't take decimals.

1 = 100%, 0 = 0%. If it can't have a decimal it can't be anything other than 0% or 1%.

Try changing the data type to double

 

[vbaInet]

Ultimately, calculated values should not be stored -->

http://allenbrowne.com/casu-14.html