SELECT mtd.COSTCTR, Sum(IIf([Month_id]=[EnterMonth],[Value],0)) AS MTD, Sum(IIf([Month_id]<=[EnterMonth],[Value],0)) AS YTD FROM mtd GROUP BY mtd.COSTCTR HAVING (((mtd.COSTCTR) Is Not Null));
Should I store the entries in the query or I can do it in the report.Umm ... as far as I know there is nothing to store.
Looking at your report, its exactly what I wanted.That is great. That would indicate it is time to close this question and start a new question with one of your newly added wants.
The first YTD calculations should be the same as the MTD ...
Or Do you want a running sum?
Also will there be a column indicating the year?