E eholtman Registered User. Local time Today, 09:41 Joined Oct 12, 2004 Messages 54 Apr 21, 2005 #1 in my query I am trying to show all items that are null and items that the date is from today and back 7 days (April 21- april 14) In the Criteria Feild I have: Criteria: Is Null or : =Now()<7 Not working
in my query I am trying to show all items that are null and items that the date is from today and back 7 days (April 21- april 14) In the Criteria Feild I have: Criteria: Is Null or : =Now()<7 Not working
john471 Registered User. Local time Tomorrow, 01:41 Joined Sep 10, 2004 Messages 392 Apr 21, 2005 #2 eholtman, Try Criteria: Is Null or :>Date()-7 And <=Date() If it is not possible for the date field to contain a future date you could use just... Criteria: Is Null or :>Date()-7 HTH Regards John.
eholtman, Try Criteria: Is Null or :>Date()-7 And <=Date() If it is not possible for the date field to contain a future date you could use just... Criteria: Is Null or :>Date()-7 HTH Regards John.
