How to select rows based on last 13 dates from a table.
Suppose today is March 15,2012 and if the table has data between
March 2012 to Jan 2000,my query should pick up data between
March 2012 to March 2011. (13 months)
Similarly, today is March 15,2012 and if table has data from Feb 2012 to Jan 2000 and the table does not have March 2012 data,then the query should pick up data from
Feb 2012 to Feb 2011. (13 months) .
I am running a query to pick up data from msaccess table to create reports. Thanks for the help!