 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2005Simple Date Query
Hi, I'm trying to develop a query in which a user would have to input just one date, and it will return records that are either equal or less than this date. Access seems to want to pull records matching that date EXACTLY, and I don't want that to happen. I also do not need to specify a date range. Anything I can do in query design view that will help this? The query is called qryFindContractsbyDate, and the field I'm looking to filter the records by is called [CONTRACT END DATE]. For Example, I'd like a parameter box to come asking for a date, and the user types in 11/30/06. I'd like any records with a CONTRACT END DATE less than or equal to 11/30/06 to come up. Thanks in advance for your help. Use this as criteria on your [CONTRACT END DATE] field in the query. >=[Enter last contract end date] > Hi, I'm trying to develop a query in which a user would have to input just > one date, and it will return records that are either equal or less than this [quoted text clipped - 6 lines] > records with a CONTRACT END DATE less than or equal to 11/30/06 to come up. > Thanks in advance for your help. Should be <= > Hi, I'm trying to develop a query in which a user would have to input just > one date, and it will return records that are either equal or less than this [quoted text clipped - 6 lines] > records with a CONTRACT END DATE less than or equal to 11/30/06 to come up. > Thanks in advance for your help. It worked! Thank you very much! >Should be <= > [quoted text clipped - 3 lines] >> records with a CONTRACT END DATE less than or equal to 11/30/06 to come up. >> Thanks in advance for your help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.