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, I went to the crosstab query and put a criteria of 1<>3 and it shows all 3 records instead of only 1 record from the form's combo box. What I am looking for is to "fill in the spaces" that are seen in the cross tab. It seems to be a pretty close solution if it wasn't for the null values between the dates in the crosstab. I am not sure if this answers your question but please let me know. thank you
i hope this is what you meant.
see the New rowsource of the combobox.
also see the code behind the command button.
Hi Arnel,
thank you. Its really close but I only ask for a tweak if possible.
You can see the null values in the below pic.How do you suggest the values would show instead of being null?
I hope I am makin sense. Let me know if you have questions.
- like i said before, each LC has different start, end date.
let take 111 for example, it started on dec-3-2021.
you don't want to fill the oct-5 or nov-1, the LC does not exists (yet) on those dates.
otherwise your boss (if you are not) or some auditor will catch this. The LC has not
been created, yet there is a retro-forecast?Hi Arnel, yes that is true that the LC did not exist yet. I would only be interested in having the data populated after it is issued and prior to this a null is OK. sorry for my tardy reply. Interested in knowing how you can solve this. I hope it is clear. Let me know if you have any questions.