How do I run a query for past calender year?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run a query in an Access database where I want to get all
records for the past 12 months and run this monthly to include all the past
full 12 motnhs. What kind of expressiondo I build in the date field?
Thanks
 
For the past 12 Months? For today's date of November 12, 2004 does that mean
From October 1, 2003 to October 30, 2004? or
From November 12, 2003 to November 11, 2004?


Criteria for the first choice is

BETWEEN DateSerial(Year(Date()),Month(Date())-13,1)
AND DateSerial(Year(Date()),Month(Date()),0)
 
Back
Top