From: dar on 27 Apr 2010 19:09
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.
"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,
> >FROM tblCustomer2
> >WHERE (((tblCustomer2.PolicyExpirationDate)>=Date() And
> 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]