Good Afternoon,
I am a new to Access, but have programmed in Excel. I was hoping someone would be kind enough to help me with an issue I am facing. I have a table with 3 columns: Cases, Hours, RIR. In the RIR column I would like to use the following formula.
Sum the last 12 rows in the cases column *200000 / sum of the last 12 rows in the hours column.
In excel, I would know how to do this, but I really would like to learn how to do it in Access 2010.
Thank you
I am a new to Access, but have programmed in Excel. I was hoping someone would be kind enough to help me with an issue I am facing. I have a table with 3 columns: Cases, Hours, RIR. In the RIR column I would like to use the following formula.
Sum the last 12 rows in the cases column *200000 / sum of the last 12 rows in the hours column.
In excel, I would know how to do this, but I really would like to learn how to do it in Access 2010.
Thank you