F fishy Mar 4, 2008 #1 I want to be able to run a query so that it shows the last 12 months data by month. Any ideas?
J John W. Vinson Mar 4, 2008 #2 I want to be able to run a query so that it shows the last 12 months data by month. Any ideas? Click to expand... Any help with your table structure? BETWEEN DateAdd("m", -12, Date()) AND Date() as a criterion on your date field will get the last twelve months data. You'll need to use a calculated field such as TheMonth: Format([datefield], "yyyy-mm") to group by the month.
I want to be able to run a query so that it shows the last 12 months data by month. Any ideas? Click to expand... Any help with your table structure? BETWEEN DateAdd("m", -12, Date()) AND Date() as a criterion on your date field will get the last twelve months data. You'll need to use a calculated field such as TheMonth: Format([datefield], "yyyy-mm") to group by the month.
