问题描述
我使用数据库跟上我的支票簿而且我遇到了麻烦
设置新功能。我星期五每两周收到一次付款,
我需要一份报告来计算我的余额,其中只包括在我下一个发薪日之前的日期
交易。在我下一个发薪日或之后的任何
交易(我已经在我银行的网站上安排了
)我想不包含在我的
余额。有没有办法做到这一点?
是的,使用dateadd()函数将14天添加到当前的
发薪日。过滤查询,以便交易日期
条件是BETWEEN发薪日和dateadd(d,14,发薪日)。
发薪日可以是传递参数或查找
-
Bob Quintal
PA是你我改变了我的电子邮件地址。
-
通过
你必须告诉它发薪日。使用相同的dateadd函数
将两周添加到已知发薪日并将其存储在表格中。
-
Bob Quintal
PA是我改变了我的电子邮件地址。
-
通过免费的Usenet帐户发布来自
I use a db for keeping up with my checkbook and I''m having trouble
setting up a new functionality. I get paid every two weeks on Friday,
and I need a report to figure my balance that includes only
transactions that are dated before the date of my next payday. Any
transactions that are dated on or after my next payday (ones I have
scheduled at my bank''s website) I''d like to have NOT included in my
balance. Is there a way to do this?
yes, use the dateadd() function to add 14 days to the current
payday. Filter the query so that the transaction date
criteria is BETWEEN payday AND dateadd("d",14,payday).
payday could be a passed parameter or looked up
--
Bob Quintal
PA is y I''ve altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
You will have to tell it the paydays. Use the same dateadd function
to add two weeks to a known payday and store it in a table.
--
Bob Quintal
PA is y I''ve altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
这篇关于报告设置,每两周一次的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!