报告设置，每两周一次 [英] Report setup, bi-weekly periods
问题描述
我使用数据库跟上我的支票簿而且我遇到了麻烦
设置新功能。我星期五每两周收到一次付款，
我需要一份报告来计算我的余额，其中只包括在我下一个发薪日之前的日期
交易。在我下一个发薪日或之后的任何
交易（我已经在我银行的网站上安排了
）我想不包含在我的
余额。有没有办法做到这一点？
rinmanb70< em ********** @ gmail。
新闻：11 ********************** @ p77g2000hsh.googlegr psps.com：
我使用数据库来跟上我的支票簿，而且我在设置新功能时遇到了麻烦。我周五每两周获得一次b / b $ b $周付款，我需要一份报告来计算我的余额
仅包括在
$之前的日期交易b $ b我的下一个发薪日。在我的下一个发薪日（我在银行网站上安排的那些）之后或之后的任何交易日期
我想不包含在我的平衡。有没有办法
这样做？
是的，使用dateadd（）函数将14天添加到当前的
发薪日。过滤查询，以便交易日期
条件是BETWEEN发薪日和dateadd（d，14，发薪日）。
发薪日可以是传递参数或查找
-
Bob Quintal
PA是你我改变了我的电子邮件地址。
-
通过 http的免费Usenet帐户发布：//www.teranews.com
但随着时间的推移，它将如何计算所有即将到来的发薪日？
rinmanb70< em ********** @ gmail.comwrote在
新闻：11 ******* ***************@g4g2000hsf.googlegro ups.com：
但随着时间的推移，它将如何计算所有即将到来的发薪日在？
你必须告诉它发薪日。使用相同的dateadd函数
将两周添加到已知发薪日并将其存储在表格中。
-
Bob Quintal
PA是我改变了我的电子邮件地址。
-
通过免费的Usenet帐户发布来自 http://www.teranews.com
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?
rinmanb70 <em**********@gmail.comwrote in
news:11**********************@p77g2000hsh.googlegr oups.com:
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
But how will it figure all upcoming paydays as time goes on?
rinmanb70 <em**********@gmail.comwrote in
news:11**********************@g4g2000hsf.googlegro ups.com:
But how will it figure all upcoming paydays as time goes on?
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
这篇关于报告设置，每两周一次的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
