计算访问中的延迟日期 [英] Calculating Late Date in Access
问题描述
每个人都有什么事?
我真的需要一些帮助。我一直在拔头发
试图研究如何计算一个迟到的日期。这是我想要做的b
:
提交的日期凭证:06年1月1日
凭证结束?:是
如果优惠券是在提交的日期凭证之后的5天。约会,我想让b $ b喜欢自动更新另一个名为VOUCHER LATE的字段
,或者是/否答案。有没有办法让这种情况发生?如果
有,我应该能够查询这个信息并创建一个报告
对吗?在此先感谢您的帮助。
What''s up Everyone?
I really need some help. I''ve been pulling the hair out of my head
trying to research how to calculate a late date. Here is what I''m
trying to do:
DATE VOUCHER SUBMITTED: 1 MAY 06
VOUCHER LATE?: YES
If the voucher is 5 days past the "DATE VOUCHER SUBMITTED" date, I''d
like to have it autmatically update another field named "VOUCHER LATE"
either with a yes/no answer. Is there a way to make this happen? If
there is, I should be able to query this info and create a report
right? Thanks in advance for your help.
推荐答案
将以下表达式放在查询的空白字段中:
LateDate:DateDiff(d,[提交日期凭证],日期())
将标准设置为:
Put the following expression in a blank field in your query:
LateDate:DateDiff("d",[Date Voucher Submitted],Date())
Set the criteria to:
= 5
查询将返回迟到5天或更多天的所有优惠券。
-
PC数据表
您的资源获取Access,Excel和Word应用程序的帮助
超过1175位用户来自新闻组请求帮助
re ****** @ pcdatasheet.com
" whiteboy" <是**************** @ langley.af.mil>在消息中写道
新闻:11 ********************** @ d71g2000cwd.googlegr oups.com ...什么是每个人?
我真的需要一些帮助。我一直把头发拉出脑袋试图研究如何计算一个迟到的日期。这就是我要做的事情:
日期提交时间:06年5月1日
VOUCHER LATE?:是
如果凭证是在提交日期凭证之后的第5天约会,我想让它自动更新另一个名为VOUCHER LATE的字段
或者是/否答案。有没有办法让这种情况发生?如果有,我应该能够查询此信息并创建报告
对吗?在此先感谢您的帮助。
=5
The query will return all vouchers that are 5 or more days late.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com
"whiteboy" <be****************@langley.af.mil> wrote in message
news:11**********************@d71g2000cwd.googlegr oups.com... What''s up Everyone?
I really need some help. I''ve been pulling the hair out of my head
trying to research how to calculate a late date. Here is what I''m
trying to do:
DATE VOUCHER SUBMITTED: 1 MAY 06
VOUCHER LATE?: YES
If the voucher is 5 days past the "DATE VOUCHER SUBMITTED" date, I''d
like to have it autmatically update another field named "VOUCHER LATE"
either with a yes/no answer. Is there a way to make this happen? If
there is, I should be able to query this info and create a report
right? Thanks in advance for your help.
" PC数据表" <否**** @ Spam.Com> schreef在bericht新闻:KO *************** @ newsread1.news.pas.earthlin k.net ...
-
"PC Datasheet" <No****@Spam.Com> schreef in bericht news:KO***************@newsread1.news.pas.earthlin k.net...
--
PC数据表
您的资源,以获取Access,Excel和Word应用程序的帮助''资源????
超过1175位用户来自新闻组请求帮助''1175位用户????
重新* *****@pcdatasheet.com
-
给Steve:
你离开的时间只有一段时间
既然没有人想要你在这里做广告/求职,你就可以待更长时间了!
825以上!来自新闻组的用户已经访问过该网站以阅读您所使用的资源...(迅速增加......)
到原始海报:
您的问题也在ms.public.access小组中回答。请不要多重信息。
关于史蒂夫:
这里的大多数人都有共同点相信新闻组是*免费交换信息*。
但史蒂夫是这些团体中臭名昭着的求职者,总是试图出售他的服务。
==> ;而且他在这里也被称为一个无耻的骗子,*根本没有道德。*
在你打算与他做生意之前看看:
http://home.tiscali.nl/arracom/whoissteve.html
Arno R
--
To Steve:
You have been away only for a little while
Since no-one wants your advertising/job hunting here you are allowed to stay away longer!
Over 825 !! users from the newsgroups have visited the website to read what kind of a ''resource'' you are... (rapidly increasing..)
To the original poster:
Your question is also answered in the group ms.public.access Please don''t multipost.
About Steve:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.
==> And he is also known here as a shameless liar with *no ethics at all.*
Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html
Arno R
" whiteboy" <是**************** @ langley.af.mil>写在
新闻:11 ********************** @ d71g2000cwd.googlegr psps.com:
"whiteboy" <be****************@langley.af.mil> wrote in
news:11**********************@d71g2000cwd.googlegr oups.com:
每个人都有什么感受?
我真的需要一些帮助。我一直在努力研究如何计算一个迟到的日期。这是我想要做的事情:
日期提交时间:06年5月1日
VOUCHER LATE?:是
如果凭证在DATE VOUCHER SUBMITTED日期之后的5天,我想让它自动更新名为VOUCHER LATE的另一个字段。或者是/否答案。是否有实现这一目标的方法?如果有,我应该能够查询此信息并创建报告吗?在此先感谢您的帮助。
What''s up Everyone?
I really need some help. I''ve been pulling the hair out of my
head trying to research how to calculate a late date. Here is
what I''m trying to do:
DATE VOUCHER SUBMITTED: 1 MAY 06
VOUCHER LATE?: YES
If the voucher is 5 days past the "DATE VOUCHER SUBMITTED"
date, I''d like to have it autmatically update another field
named "VOUCHER LATE" either with a yes/no answer. Is there a
way to make this happen? If there is, I should be able to
query this info and create a report right? Thanks in advance
for your help.
像往常一样,PC数据表的答案是不完整的,并且没有
满足要求。 />
而不是他写的东西,
LateDate:DateDiff(d,[提交日期凭证],日期())
您需要将datediff函数嵌入到iif语句中。
创建更新查询。打开[优惠券延迟]字段。 。
把它放在行的更新中。
iif(DateDiff(" d",[Date Voucher Submitted],Date( ))> = 5,-1,0)
(注意换行。)
-
Bob Quintal
PA是我改变了我的电子邮件地址。
As usual PC Datasheet''s answer is incomplete and does not
satisfy the requirements.
Instead of what he wrote,
LateDate:DateDiff("d",[Date Voucher Submitted],Date())
you need to embed the datediff function into an iif statement.
Create an update query. bring down the [Voucher Late] field. .
put this in the update to row.
iif(DateDiff("d",[Date Voucher Submitted],Date()) >=5, -1,0)
(watch out for linewrap.)
--
Bob Quintal
PA is y I''ve altered my email address.
这篇关于计算访问中的延迟日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!