Forum Discussion
Solved
Forecast
Hello experts, I want to develop a query that will forecast the value of an asset. There is an initial value and an amendment on a certain date in the future, and an expiration date The query w...
- the query 1_qryTotalAmends is a Total query.
it is just summing the LC by Date.
there are 2 amendments on date jan-03-2022, (50 and -25).
so summing them will be 25.
also this only first step (as prefixed by 1_), the final query is numbered 4_.
if you can see each query, i am building the final, one query over the other.
Arnel, thats amazing. I wish I could do that.
Question:
The first amendment for LetterOfCreditID = 1 is negative and I think it shows positive below? The next amendment is -250 and it shows as a -250
the query 1_qryTotalAmends is a Total query.
it is just summing the LC by Date.
there are 2 amendments on date jan-03-2022, (50 and -25).
so summing them will be 25.
also this only first step (as prefixed by 1_), the final query is numbered 4_.
if you can see each query, i am building the final, one query over the other.
it is just summing the LC by Date.
there are 2 amendments on date jan-03-2022, (50 and -25).
so summing them will be 25.
also this only first step (as prefixed by 1_), the final query is numbered 4_.
if you can see each query, i am building the final, one query over the other.
- I see what you are saying now. Ok. thank you so much. Very grateful for your help. that code is amazing.