Review the last years data by month

[PaulJR]

I have created a crosstab query that displays data by month, using SLQ statement 'Expr1: Format([Date],"mm-yy")". 'Date' is a field in my table that is formatted as dd-mm-yyyy that is entered for each record.

My problem is that I can't figure out how to restrict the query to display data for the past 12 months only. I think I need to add a new column to the query to filter on the last years data but I can't work out how to write the statement. Would really appreciate any advise.

Paul

 

[DCrake]

Simple Software Solutions

First of all don't use the word Date as a field in a table. Access does not like it. See reserved words in Access.

Also you need to add an extra column in your crosstab query that is neither a row or a column - leave blank. And in the criteria section enter your date range accordingly. Don't forget to untick the show field check box.

CodeMaster:

 

[PaulJR]

Thank you CodeMaster, that is absolutely brilliant! I can now automate my metrics at long last