If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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] . |
|
Thread Tools | |
Display Modes | |
|
|