Currently, I have a query that needs to gather all records based on [AS of DATE] but it needs to be on a single report plotted by months. Example: All records as of [01/01/2012] = 100, second parameter - all records as of [02/01/2012] = 150, third parameter - all records as of [03/01/2012] = 200 and so on until december.
Right now, I have created a query for each parameter to gather all records and then create another query to sum it up. That's 24 queries which means more than likely, I am doing something wrong :-(
Is there any other way to accomplish this?