与两个时间字段的区别：MS Access [英] Difference from two time fields: MS Access

问题描述

嘿伙计们！


我遇到了一个谜题;以下查询在Access 2000中获取了我需要的内容（两个时间字段的差异）但在MS Access 2003中没有，任何想法为什么：

Hey Guys!

I ran into a puzzle; below query gets me what I need (Difference from two time fields) in Ms Access 2000 but not in MS Access 2003, any idea why:

展开 | 选择 | Wrap | 行号

推荐答案

2003年设置中缺少参考？


Linq ; 0）>

Missing reference in the 2003 set up?

Linq ;0)>

在2003年设置中缺少参考？


Linq ; 0）> ;

Hey there missinglinq！


我不确定你的意思。您是否认为安装此版本时未添加任何内容？


如果是这样的话，有什么补救措施？


感谢您的回复！


D？k？ll

Hey there missinglinq!

I am not sure how you mean. Do you suppose when this version was installed something was not added?

What''s the remedy for that, if this is the case?

Thanks for replying!

D?k?ll

随着时间的推移，在给定的安装/版本的Access中，新功能/需要这些函数，并且为了提供其中的一些函数，添加了新的引用库。随着时间的推移，我们倾向于忘记这一点，我们会自动使用这些功能。但是新安装仅安装非常基本的库，因此可能缺少一些所需的库。这里是Allen Browne关于检查这种问题并修复它的论文的链接：

http://allenbrowne.com/ser-38.html


任何时候你有功能/代码'一直工作正常，当你在同一台PC上移动到另一个安装/版本时它会中断，你需要考虑缺少引用。还将应用程序移动到另一台计算机并让它打破调用以检查引用。我甚至听说过应用Service Pack导致了这个问题的情况，但是不记得涉及的版本/ SP。


Linq ; 0）>

As time goes by in a given installation/version of Access, new features/functions are needed, and in order to provide some of them, new refernce libraries are added. We tend to forget this as time goes by and we get use to using these functions automatically. But a new installation only installs the very basic libraries, and so some of the needed libraries may be missing. Here''s a link to Allen Browne''s paper on checking for this kind of probelm and fixing it:

http://allenbrowne.com/ser-38.html

Anytime you have functions/code that''s been working fine and it breaks when you move to another installation/version on the same PC, you need to think about missing references. Also moving an app to another machine and having it break calls for checking the references. I have even heard of cases where applying service packs have caused this problem, but can''t remember the version/SP involved.

Linq ;0)>

这篇关于与两个时间字段的区别：MS Access的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！