percentage data types

[Jake]

What number field should be used to optimize performance and record
percentages such as 25.56% and then total percentages across records?
thanks,
Jake

 

[Ken Snell [MVP]]

Try Currency.

 

[John Vinson]

What number field should be used to optimize performance and record
percentages such as 25.56% and then total percentages across records?
thanks,
Jake

A percentage is just a number. 25.56% is simply a way of displaying
the number 0.2556; there is no separate "percentage" datatype, of
course!

A Number... Double will work with good performance; its one limitation
is that a Double is an approximation, accurate to about 14 decimal
places, so that it's possible that 33% + 33% + 34% will not in fact
eaual 100% - it might result in 99.999999999997% or 100.00000000002%
due to roundoff error. If that isn't acceptable, use a Currency
datatype; the tradeoff is that you're stuck with four and only four
decimal places, i.e. 25.56% can be stored, but 25.565% cannot.

John W. Vinson[MVP]