Unanswered: Update query using newly updated values
I am trying to use an update query to perform multiple updates at one time. For simplicities sake, I will use the most basic example here. [This problem could be solved for this specific example by creating another query to run afterwards, but with the more complex data, it is not practical to create endless queries.]
My problem is this: I pull in a date based on other criteria and that updates fine, but I need the next five instances of that date which would be this calculated date +1, +2, etc. When I run the code it adds one, two, to the NON-updated date. I have to either loop it five times or make a new query that runs after the old data has been updated. Is there any way within a single query to have other fields update based on previously (within same query) updated fields? Hopefully this isn't too confusing, here is my code below.
So I would like TrueUpYear_1 to update before TrueUpYear_2 is calculated, TrueUpYear_2 before TrueUpYear_3, etc.
As I said, I know this is a somewhat simple fix to move 2-5 to another query, but there are much more complex versions of this project where each value is based on the previous so I really need to know how to get these to update before the next calculation.