使用表单通过输入certian日期来搜索访问数据 [英] Using a form to search for access data by entering certian dates
问题描述
您好,
我目前正在开发一个大型数据库。我希望用户能够通过输入他们选择的开始和结束日期来搜索某些记录。
I am currently working on a large database. I would like for a user to be able to search for certain records by entering a start and end date of their choosing.
我目前有具有指定日期和发布日期的表格。
I currently have a table with an assigned date and a released date.
我希望用户能够查看基于该记录的每周记录报告他们选择的开始和结束日期。
I want the user to be able to view a weekly report of records based on the start and end dates they choose.
例如:
用户将开始日期定义为2/06/2017,结束日期为2/10 / 2017.
User puts in Start Date as 2/06/2017 and End Date as 2/10/2017.
报告应生成截至2017年2月10日的所有未发布记录,并且仅在输入日期之间发布记录。
The report should generate all NON released records up to 2/10/2017 and ONLY released records between the dates entered.
这可能吗?
我非常感谢你能给予的任何帮助。
I would greatly appreciate any help you can give.
推荐答案
你可能会尝试类似:
ReleaseDate> = [输入开始日期]和AssignedDate< = [输入结束日期]
ReleaseDate >= [Enter Start Date] AND AssignedDate <= [Enter End Date]
希望它有所帮助......
Hope it helps...
这篇关于使用表单通过输入certian日期来搜索访问数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!