To correct the problem I have decided to change the columns DataType from Float(Length: 8, Precision: 53) to Decimal(Length: 9, Precision: 18, Scale: 2).

Any comments/notes regarding my decision?

jxflagg,

I'm not looking to round the sum to an interger.

ThomasH,

Your suggestion is causing the following error "Arithmetic overflow error converting float to datatype numeric"

Here is sample data from one of...