Hi Guys,
I have a requirement in which I need to carry forward the result value of a previous record to the Actual value of a new record and this process to continue until the result value gets to 0 and all this is happening in an access form. For e.g.
RecodStat | Actualval | Inputval | ResultVal
First record | 10(MF) | 5(MF) | 5(CF)
CF to new record | 5(CFWD) | 3(MF) | 2(CF)
CF to new record | 2(CFWD) | 2(MF) | 0(CF)
Note: Manual Feed - (MF), Calculated field (CF), Carry Forward (CFWD)
For the first record - manual feed for Actualval and Inputval
carry forward to new record - manual feed for Inputval only
I was able to do this by select and insert sql queries but I'm sure there could be a better approach to this requirement.
Please help me with your valuable inputs and let me know if any further details are required.
Thanks again,
Rakesh
I have a requirement in which I need to carry forward the result value of a previous record to the Actual value of a new record and this process to continue until the result value gets to 0 and all this is happening in an access form. For e.g.
RecodStat | Actualval | Inputval | ResultVal
First record | 10(MF) | 5(MF) | 5(CF)
CF to new record | 5(CFWD) | 3(MF) | 2(CF)
CF to new record | 2(CFWD) | 2(MF) | 0(CF)
Note: Manual Feed - (MF), Calculated field (CF), Carry Forward (CFWD)
For the first record - manual feed for Actualval and Inputval
carry forward to new record - manual feed for Inputval only
I was able to do this by select and insert sql queries but I'm sure there could be a better approach to this requirement.
Please help me with your valuable inputs and let me know if any further details are required.
Thanks again,
Rakesh