Query 90 expiration

Thank you John it worked! I must have typed something wrong the first time.
i went back a couple of times and found it. I had to many spaces.

Thanks again

"John W. Vinson" wrote:

On Tue, 27 Apr 2010 10:30:02 -0700, dar wrote:

PolicyExpirationDate is set to Date/Time

SELECT tblCustomer2.CustomerName, tblCustomer2.ContactName,
tblCustomer2.ContactNumber, tblCustomer2.PolicyNumber, tblCustomer2.Carrier,
tblCustomer2.Premium, tblCustomer2.PolicyExpirationDate,
tblCustomer2.PolicyType
FROM tblCustomer2
WHERE (((tblCustomer2.PolicyExpirationDate)=Date() And
(tblCustomer2.PolicyExpirationDate)=Date()+7)) ;

If you run that query today that should find only records with
PolicyExpirationDate in the range from #4/27/2010# to #5/4/2010#.

If it doesn't please post a few rows of your data indicating the dates that
violate these conditions. That's wierd.
--

John W. Vinson [MVP]
.