I am trying to build a query which will find experation dates of products within 90 days
D Dgwood90 May 23, 2006 #1 I am trying to build a query which will find experation dates of products within 90 days
R Rob Parker May 23, 2006 #2 Assuming that you mean within 90 days in the future, in the criteria for the expiry date field, put: =Date() And <DateAdd("d",Date(),90) Click to expand... If you want those within the past 90 days, use <=Date() And >DateAdd("d",Date(),-90) HTH, Rob
Assuming that you mean within 90 days in the future, in the criteria for the expiry date field, put: =Date() And <DateAdd("d",Date(),90) Click to expand... If you want those within the past 90 days, use <=Date() And >DateAdd("d",Date(),-90) HTH, Rob
