I would use Between Date() And Date()-120
Dawn Crosier Microsoft Word MVP "Education Lasts a Lifetime" This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Boehm, Gary D. Sent: Tuesday, September 11, 2007 1:38 PM To: '[email protected]' Subject: [ms_access] Calculating # of days I am building a query that includes a statute of limitations date field. I want the criteria to be "120 days or less from today" How do I express that in the criteria? Gary No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.485 / Virus Database: 269.13.14/1001 - Release Date: 9/11/2007 1:37 PM Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
