Hi,
I would like to create a graph in Access as a Stacked Column one. X-axis: Year_Month (2020-04 e.g.) and Y-axis: a summary of 'actual' and 'forecast' revenue each month. Preferably different colours in the graph.
I've today two different queries. One filtering out 'actual' (revenue that we've orders on) and the other query filtering out the forecast. These are fine and the outcome seems ok. Now to the last step; How to get these two queries together and be presented in the very same graph?
I tried to create an addtional query with these two above queries, and then I just choosed Year_Month field from one query (and this field has the same name in the two already created queries). But the result is not as expected, and I could anticipate this from the very beginning. Now I need some advice I think...
And related to this I've another question regarding to spread out a total revenue sum on several months. Above I only use starting date where I put the total revenue, which is not the actual reality. I would like to make it little more accurate if possible.
For each project I've the total revenue sum, starting date and the number of days each project will run. Now I would like to spread out the total revenue between starting date and the end date for each project (if possible considering working dates). And then summarize all projects in periods as above (2020-04 e.g.) Is there anyone who has a good idea how to solve this?
Maybe I need to do something in VBA and create a new table? Or is there any more simpler solution?
Greatful for any advice I can get!
I would like to create a graph in Access as a Stacked Column one. X-axis: Year_Month (2020-04 e.g.) and Y-axis: a summary of 'actual' and 'forecast' revenue each month. Preferably different colours in the graph.
I've today two different queries. One filtering out 'actual' (revenue that we've orders on) and the other query filtering out the forecast. These are fine and the outcome seems ok. Now to the last step; How to get these two queries together and be presented in the very same graph?
I tried to create an addtional query with these two above queries, and then I just choosed Year_Month field from one query (and this field has the same name in the two already created queries). But the result is not as expected, and I could anticipate this from the very beginning. Now I need some advice I think...
And related to this I've another question regarding to spread out a total revenue sum on several months. Above I only use starting date where I put the total revenue, which is not the actual reality. I would like to make it little more accurate if possible.
For each project I've the total revenue sum, starting date and the number of days each project will run. Now I would like to spread out the total revenue between starting date and the end date for each project (if possible considering working dates). And then summarize all projects in periods as above (2020-04 e.g.) Is there anyone who has a good idea how to solve this?
Maybe I need to do something in VBA and create a new table? Or is there any more simpler solution?
Greatful for any advice I can get!
