Hey all, I've been banging my head over my keyboard for the last 3 days over this. Hope someone can give me a hint.

Scenario:
Infopath form originally linked to an Access database.
Access database exported to SQL server.
Infopath linked to SQL Server.
I have 7 fields that I'm trying to add together using a function/formula. It looks like this:
total = a+b+...+g

The numbers are in currency form. When attempting to submit the data it always spits back an invalid data error. It happens whenever the hundredths' digit is an even number, but not when it's odd or 0.

I'm stumped. Could this be a bug within the program? Any suggestions would be greatly appreciated. Thanks.