当日期在两个字段值之间时查询 [英] query when a date is between two field values
问题描述
我正在试图通过在2个日期条目之间选择一个日期来弄清楚如何使查询工作。
这是(有点)数据库的方式作品:
当操作员离开时,用户输入开始日期和结束日期。
我运行一份报告,找出我指定的日期是什么操作员。
如果我从(开始日期)10/11/2006到(结束日期) )2006年11月13日。
我必须创建什么类型的查询才能获得该操作在12/11/06上出现? (当我在查询中输入12/11/06时)
我知道它有点模糊,任何帮助/指针都会很棒!
I''m trying to figure out how to get a query to work by picking up a date in between 2 date entries.
this is (kind of) how the database works:
User put in the ''Start Date'' and ''End Date'' for when an operator is out.
I run a report to find out what operators are out a date I specify.
So say if I have an op out from (start date) 10/11/2006 to (end date) 13/11/2006.
What kind of query would I have to create so it picks up that that op is out on the the 12/11/06? (when I enter 12/11/06 into the query)
I know its a bit vague and any help/pointers would be great!
推荐答案
这个想法将是这样的:
The idea would be something along the lines of :
我不是100%肯定我关注...我得到了介于...之间...但我不确定我的MS Access技能是否如何让它工作....我可以在这里发布我的数据库供人们查看或者我有点多了???
再次感谢您的帮助
Im not 100% sure I follow... I get the the between bit... but I''m not sure my MS Access skill strech as far as to how to get it to work.... can I post my DB on here for people to look at or i that a bit much???
Thanks again for the help
最好是清楚地表达你的问题。
SQL查询已经完成。是不是你不知道如何在Access中从这个SQL代码创建一个保存的查询(QueryDef)?
如需更详细的帮助,你可能需要为你的数据库发布一些元数据。
发布表/数据集元数据
Better would be to express your problem clearly.
The SQL query is done already. Is it that you don''t know how to create a saved query (QueryDef) in Access from this SQL code?
For more detailed help you will probably have to post some Meta-Data for your database.
Posting Table/Dataset MetaData
这篇关于当日期在两个字段值之间时查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!