John - THANK YOU! That works!
It looks like I was getting hung up in setting the criteria on the Date Arrived field, instead of creating a separate field to perform the calculation. Also, I had not thought to use DateSerial. I'm definitely adding this to my code library so hopefully, if it comes up again, I'll won't have to struggle so hard. Dawn Crosier Application Specialist "Education Lasts a Lifetime" -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Thursday, January 05, 2006 3:31 PM To: [email protected] Subject: RE: [ms_access] Date Criteria Dawn- Like this: SELECT Format([Date Arrived in PCC],"mm/yyyy") AS [Date Arrived], Avg(Format(WorkDays([Date Arrived in PCC],[ECO Routing Complete]),"#,###.0")) AS [Work Days], Count(tblReleases.[ECN Number]) AS [Number of ECN's] FROM tblReleases WHERE (tblReleases.[ECN Class]=[Forms]![frmECNPriority]![ECN Class]) AND (tblReleases.[Date Arrived in PCC] >= DateSerial(Year(Date()), Month(Date())-13, 1)) GROUP BY Format([Date Arrived in PCC],"mm/yyyy"), tblReleases.[ECN Class] ORDER BY Format([Date Arrived in PCC],"mm/yyyy"); So, if today is January 5, 2006, the query should return all records from January 1, 2005 onwards. If today is February 20, 2006, the query returns all records on or after February 1, 2005. Is that what you want? Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
