have an Escalation database which has a subform which contains a series of price adjustments. The first price adjustment is based on the initial rate in the main form but I need to program the form so it calculates on the 'current rate' from the latest record in the subform. I have tried to write the PDL (below) but am completely new at this and have a problem with a circular calculation as I describe below - can anyone point me in the right direction? Please bear in mind I am new at this.
‘Create rolling calculation for rate adjustment database
‘where Initial Rate is in the main form and subform is a continuous form
‘Initiate Calculation program through a button
‘On Click check to see if New Rate is null
‘If null calculate New Rate =[New Exchange Portion]+[New Shop Rate Portion]
‘If not null, calculate New Rate =
‘Ok, this is where I get confused because most calculated fields in the subform are calculated when new data is manually entered into the Parts and Exchange Increase fields, but the calculations are based on a percentage of the ‘current rate’ field which I would like to pull automatically from the New Rate field in the last record. I think this would simply create a circular calculation - I know my head is spinning!
Any advice?
‘Create rolling calculation for rate adjustment database
‘where Initial Rate is in the main form and subform is a continuous form
‘Initiate Calculation program through a button
‘On Click check to see if New Rate is null
‘If null calculate New Rate =[New Exchange Portion]+[New Shop Rate Portion]
‘If not null, calculate New Rate =
‘Ok, this is where I get confused because most calculated fields in the subform are calculated when new data is manually entered into the Parts and Exchange Increase fields, but the calculations are based on a percentage of the ‘current rate’ field which I would like to pull automatically from the New Rate field in the last record. I think this would simply create a circular calculation - I know my head is spinning!
Any advice?
