Hello everyone
I need to do this on my database...My main table is tblReturns, and I have a form called Returns. Now inside that I have a field called %MTD which is the percentage return a user will enter every month. I have placed a caculated control on the form that is =100*(1+[%MTD])
Now I need to a)Store tis value in my table in the cumreturns field (this I think I can manage)
b)But then I need this field to change its calculation next month. SO next month it would not be 100*(1+[%MTD]) but whatever was the cum return for the last month*+[%MTD]) and so on for every month. This is easy enough to set in Excel by cell references for the last cell...but how do I do this in Access? Help!
Thanks!
I need to do this on my database...My main table is tblReturns, and I have a form called Returns. Now inside that I have a field called %MTD which is the percentage return a user will enter every month. I have placed a caculated control on the form that is =100*(1+[%MTD])
Now I need to a)Store tis value in my table in the cumreturns field (this I think I can manage)
b)But then I need this field to change its calculation next month. SO next month it would not be 100*(1+[%MTD]) but whatever was the cum return for the last month*+[%MTD]) and so on for every month. This is easy enough to set in Excel by cell references for the last cell...but how do I do this in Access? Help!
Thanks!