I am trying to create a simple 2-D bar chart in Access 2010. There are several thousand records with the following fields: [Effective_Date], [Cancel_Date], and [Amount] ($). Records represent contracts that may span 1 to 30 years between Effective_Date and Cancel_Date. What I am looking to do is show on December 31 of each year (from 1986 to current year) the total dollar value of contracts in effect on that day using the chart tool.
I have created charts for gains & losses in any one year but can't seem to put my head around this.
Any help is appreciated.