如何使用“从”和“到”来计算总值。 [英] How do i count a total of a value using a From and to date.
本文介绍了如何使用“从”和“到”来计算总值。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
请帮助，（Access 2003）
我已经成功完成了我的计数表达（正如你在我的截图中看到的那样），但我想我们每周都会运行此查询，因此我们会每周运行此查询。
我们的想法是知道每位律师每周都有多少查询。
这可能吗？
如果有的话，有人可以帮我解释这个表达。
问候
凯尔
Help Please, (Access 2003)
I have made the expression for my count which i have done successfully (as you can see on my screenshots), but i would like to use a from and to date as we would run this query on a weekly basis.
The idea is to know how many enquiries each of our lawyers have had each week.
Is this possible?
If so could someone help me with the expression please.
Regards
Kyle
推荐答案
您可以在日期字段中使用Between语句。例如
You would use the Between statement on your date field. For example
展开 | 选择 | Wrap | 行号
谢谢，
它只会提取日期，如果它是在桌子上我正在进行查询。
请记住我已经在我的桌子上建立了关系。
Thank you,
would it only pick up the date if it was on the table i was doing the query on.
Bearing in mind i have set up the relationships on my tables.
只要具有Date字段的表包含在查询中，然后您可以在条件中使用它。
As long as the table that has the Date field is included in the query, then you can use it in the criteria.
这篇关于如何使用“从”和“到”来计算总值。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
