How "deep" can you go with calculated controls?
I have a sub-form with a calculated control, whose control source is a query which is also doing a calculation. I have another control which I was trying to do ANOTHER calculation based off the previous control, but it won't return the desired value. It only returns the value based off the "first" layer, the calculation being done within the query and not the calculation being done within the previous control.
Layer 1 is the base query
Layer 2 is the first control based off the query
Layer 3 is the second control based off the first control - this is where it seems to break.
Am I doing this wrong? Or is this not something I can do? This is a sub-form that is just displaying a breakdown of values along with totals, hence all the calculations being done.
Would this maybe require another query based off the first query?
I have a sub-form with a calculated control, whose control source is a query which is also doing a calculation. I have another control which I was trying to do ANOTHER calculation based off the previous control, but it won't return the desired value. It only returns the value based off the "first" layer, the calculation being done within the query and not the calculation being done within the previous control.
Layer 1 is the base query
Layer 2 is the first control based off the query
Layer 3 is the second control based off the first control - this is where it seems to break.
Am I doing this wrong? Or is this not something I can do? This is a sub-form that is just displaying a breakdown of values along with totals, hence all the calculations being done.
Would this maybe require another query based off the first query?