This Access VBA is using a For Next loop and I understand most of the code but I have some areas that I'm not sure about. Can someone give me some in depth detail on the following code:
sngAmount = sngAmount + (sngAmount * (strRate / 100 / 12))
I understand the above is the formula for calculating the interest earned but I don't quite get dividing by "100" is that to make it currency to allow for two digits after the amount is achieved from the calculation?
I don't understand making the following variables as the data types chosen:
intI being "Dim" As integer
Why not make them all "single" or "double" how is a string even used in a math problem?