I used the following function to pull the records from October of 2010:
POST DATE: DateAdd("m",-13,Left(Date(),2) & "/" & Right(Date(),4))
But I need to pull a Rolling 12 Month query (actually, I need November 2010 through October 2011). I tried putting And and then repeating the function with changing the -13 to a -12 and I was going to do that until -1, but it only returned all records as -1?
I need to know how I can pull this information please.
Thankyou in advance for helping me.