data entries for 11 months ago for the entire month

  • Thread starter Thread starter zerowarrior
  • Start date Start date
Z

zerowarrior

Hi. im bit stuck. i need a formula for access whereby it will return
all date entries put in 11 months ago. e.g. today is 05/2007 it will
return all the entries put in for 11 months previous for the entire
month which would be all entries for june. Please help.
 
Field: EntryDate
Criteria: Between DateSerial(Year(Date()), Month(Date())-11,1) and
DateSerial(Year(Date()), Month(Date())-10,0)

If that is off adjust the -11 and -10 by one each to change the number
of months in the past.

Explanation of the 0 day. The zero day of any month is one day prior to
the 1st day of the month. The day prior to the first of any month is
the last day of the month prior - that is 1 minus 1.



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top