日期查询 [英] Date queries

问题描述

很抱歉重新打开此主题。但我仍然无法解决这个问题。我使用的代码是

Hi,

Sorry to be reopening this thread. but i am still unable to get this solved. The code i have used is

展开 | 选择 | Wrap | < span class =codeLinkonclick =LineNumbers（this）;>行号

推荐答案

我认为你的问题是日期 - 3.如果你指的是系统日期，语法应如下所示：Date（） - 3

I think your problem is with Date - 3. If you are referring to the system date, the syntax should be as follows: Date() - 3

我认为你的问题是日期 - 3.如果您指的是系统日期，语法应如下所示：Date（） - 3

I think your problem is with Date - 3. If you are referring to the system date, the syntax should be as follows: Date() - 3

当我尝试这样做时，paranthesis（）刚刚消失了它最终变成了现在的样子。我无法改变它。

When i tried doing that, the paranthesis () just disappeared. and it ended up being the way it is now. Am unable to change that.

由于Access正在寻找没有WHERE的SQL字符串子句，我想你应该尝试类似的东西：

Since Access is looking for an SQL string clause without the "WHERE", I think you should try something like:

展开 | 选择 | Wrap | 行号

这篇关于日期查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！