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
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