Use
Ø Now()+90 and <= Now() +180
papparuff
John V. Ruff The Eternal Optimist J
Commit to the Lord whatever you do,
and your plans will succeed. Proverbs 16:3
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Bill
Sent: Thursday, May 01, 2008 7:09 PM
To: [email protected]
Subject: [ms_access] Date Query
Hello All I have a query I run to tell me when expiry dates for records
fall within 90 days of todays date I use this expression in my expiry
date column <=Now()+90 now I would like to do the same query for 180
days but I want to exclude the records returned in the first query so
it tells me which ones will expire after 90 but before 180 I am very
new to the expressions for the criteria so please forgive me if this is
a very n00b question any help or info would be great thanks in advance
Bill
[Non-text portions of this message have been removed]
