R rwpetrie Registered User. Local time Today, 08:14 Joined Dec 12, 2000 Messages 25 Nov 15, 2001 #1 What expression do I type in my criteria so that it will only show the results with the date field within the last week?
What expression do I type in my criteria so that it will only show the results with the date field within the last week?
Graham T Registered User. Local time Today, 08:14 Joined Mar 14, 2001 Messages 300 Nov 15, 2001 #2 Try using >=(Now()-7) This should return all records with dates within the last 7 days. HTH
R rwpetrie Registered User. Local time Today, 08:14 Joined Dec 12, 2000 Messages 25 Nov 15, 2001 #3 Thank you! It works great!
