Experts of Ms Access I need your help again...
I posted my concern way back in this forum but still I cant get it work. I need your help again.
The problem is that, I wanted to work on changes of calculation per row. I attached a photo to make it much clearer.
In Design Engineering:
If the amount is 7,331 then users pick a Year, lets say 2011, that 7,331 will change and have an increase of 110% based on the change of amount per year. Then again, if the user pick a Rate Basis, lets say EST (Estimated) the amount 8,064.1 (after an increased in picking a Year) will increase again according to the Rate Basis choosen, it will become 9,676.92.
Its like, amount on the left side (Cost Estimate Facilities) will always increase according to what the user pick whether Year or Rate Basis BUT, changes should have an effect only per row not the entire Form because on the next Cost Estimate Facilities - Project Mngt O/H (OWner PMT) should have the same function but it has a different amount than the others.
Design Engineering has its calculation getting its Source from a Query - [Unit Weight] * 850 * [Escalation] * [Contingency]
All of the data is in a Table, and all calculations are in the Query.
Should I create a new Table for this? Should I create a new Query for this? What to use in the Form - Subreport? Combobox?
Please help....
Thanks.