I would like to design a querie that selects all records with in the past twelve months for use in a Year to date comparison report. This report will look at the previous 24 months and compare them to one another and calculate the % Change.
I have tried using
But nothing is selected when I run this query.Code:SELECT [Phone Log].* FROM [Phone Log] WHERE ((([Phone Log].[Date/Time]) Between Year(Date()) And Year(Date())-1));