In excel if I want to find the last day of the current month I can use the following formula
=EOMONTH(TODAY(),0)
I have an access database with a table that contains , Accounting Date, Quantity. I would like to use a formula to generate a rolling 12 month graph. With the current month being the 12th month.
Current Static Formula
( Mar Qty: Sum(IIf(Month([tbl_Stores]![Accounting Date])=3,[tbl_Stores]![Quantity],0))
What functions / formulas would I use to generate a dynamic rolling 12 month query
Thanks in advance
=EOMONTH(TODAY(),0)
I have an access database with a table that contains , Accounting Date, Quantity. I would like to use a formula to generate a rolling 12 month graph. With the current month being the 12th month.
Current Static Formula
( Mar Qty: Sum(IIf(Month([tbl_Stores]![Accounting Date])=3,[tbl_Stores]![Quantity],0))
What functions / formulas would I use to generate a dynamic rolling 12 month query
Thanks in advance