如何查看具有日期范围标准的报告 [英] How to View Report with Date Range Criteria

问题描述

大家好我目前有一个带有两个文本框的表单，以便用户可以输入他们希望在报告中显示的日期。


该报告包含多个客户端页面和他们购买订单的日期。


按钮子程序下的内容如下：

Hello everyone I currently have a form w/ two text boxes so that the user may enter the dates they wish to display in the report.

The report consists of multiple clients per page and the date that they purchased an order.

What I have under the button sub procedure is the following:

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

推荐答案

尝试在条件字符串中添加空格AND像这样...

try putting spaces in your criteria string surrounding "AND" like so...

展开 | 选择 | Wrap | 行号

当您传递类似日期文字时，必须将它们括在日期中sign＃就像用双引号括起字符串文字一样。

When you pass date literals like that, they must be enclosed in date signs # in the same way you enclose string literals with double quotes.

展开 | 选择 | Wrap | 行号

谢谢大家的回复。我使用了TheSmileyOne提供的语法，但仍然得到运行时错误。运行时错误30025：无效的SQL语句。检查过滤器表单记录源。


突出显示同一行

Do.Cmd OpenReport rptName，acViewPreview ,, Criteria


我不知道该怎么办。任何帮助将非常感激。再次感谢大家！

Thank you all for your replies. I have used the syntax TheSmileyOne has provided and still get the runtime error. Runtime Error 30025: Invalid SQL Statement. Check filter form record source.

It highlights the same line
Do.Cmd OpenReport rptName, acViewPreview, , Criteria

I have no clue as to what to do here. Any help would be much appreciated. Thanks again everyone!

这篇关于如何查看具有日期范围标准的报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！