criteria for within a year previous to a specified date from a control

[SirStevie3]

I'm setting up some analytical reports and i'm having a hard time with some date criteria.

I've gotten monthly averages already and what i want to do is take those monthly averages, and average them throughout the year. (the year being from the specified date on a form control back one year)

Month([Forms]![Report Runner]![Date1]) and Year([Forms]![Report Runner]![Date1]) worked great for specifying a certain month in a certain year, but what i'd like is to show all the monthly numbers for every month going back one from [Forms]![ReportRunner]![Date1].

i tried this:

>(Year([Forms]![Report Runner]![Date1])) And <((Year([Forms]![Report Runner]![Date1]))-1)

and it didnt work. any ideas on how to do this?

 

[Mihail]

Take a look here:
http://technet.microsoft.com/en-us/library/ms186819.aspx

 

[SirStevie3]

thank you Mihail!