Hi,
I've ready many posts before posting this question. Although there are other posting on this subject, no suggestions have worked so far. I've used this simple parameter criteria in queries before and can't figure out why it won't work now. The query is based on a select query with some expressions and a table. The field in question is the Expiration date field. I used the BETWEEN [Start Date] AND [End Date] in the criteria area. When I choose 1/1/12 as the start date and 8/9/12 as the end date, it returns records with the expiration dates of 7/11/14, 2/1/12, 1/18/15, and 1/25/16. It is only returning the correct month and day, not year. I have formatted this as general date, format([Expiration Date],"mmddyyyy"), you name it. This is my Sql for the query:
Code:
SELECT Contracts.Contract_ID, Contracts.Contract_Status, Contracts.Primary_Vendor_Name, Contracts.Start_Date, Contracts.Contract_Type, Contracts.Contract_Category, Contracts.Description, Contracts.Neg_Contract_Value, Contracts.Initial_Contract_Value, Contracts.COE, Contracts.[Legal Entity], Contracts.Sub_cat, Contracts.[Multi-Party], Contracts.Original_ext_party, Contracts.[Term Type], Contracts.Effective_Date, Contracts.Initial_term_months, Contracts.[Auto-Renewal_Term], Contracts.Auto_Renewal_Notification_Period, Contracts.Renewed, Contracts.Termination_Convenience, Contracts.Termination_Notice_Req, Calcs.[Termination Notice], Calcs.[Renewal Notice], Calcs.[Expiration Date]
FROM Calcs INNER JOIN Contracts ON Calcs.Contract_ID = Contracts.Contract_ID
WHERE (((Calcs.[Expiration Date]) Between [Start Date] And [End Date]));
Thank you!