Hi there,
This is a short one and I hope someone has come accross this as well.
I have a text box (txtAmount) which has a calculation for its value. The calculation multiplies two fields together.
One field stores a number of days (Days) worked by someone. This is stored as a decimal. The other stores Currency amounts. (Costs). Sometimes depending on the Currency amount I get an "Invalid Data' error around txtAmount. For example, if (Days) has the value 1.2 and it multiplies £471, I get the error. If (Days) is 1.75, I don't get the error.
The calculation is this:
@Days * @Cost
Does anyone know why this is and if there's anything I need to do to prevent this error.
Thanks for any help.