From: dar on
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 <dar(a)discussions.microsoft.com> 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]
> .
>