See simplified database attached.
See tblWhichMonth. This very (very) simple table simply indicates which month we are currently processing.
See tblSalesByMonth which has a "sales" figure for each of the 12 months of the year.
I need a query that show my "Year To Date" sales figure. That's it!
So for instance, if the tblWhichMonth.CurrentMonth
= 4 then the total sales will be the sum of the first 4 "SalesValue" in the tblSalesByMonth