日期范围报告 [英] Date Range Report

问题描述

您好我尝试从名为qrycustomerinformation的查询创建日期范围报告。包含我的日期值的字段称为Followup。当我对此运行报告时，它很好。但我已决定将此报告用于特定日期范围。香港专业教育学院尝试在allen brownes页面http://allenbrowne.com/casu-08.html上使用该方法。我还想提到后续字段也使用此代码生成从输入记录的日期起三个月的日期= DateAdd（m，3，[Date]）。输入报告的日期范围时，它接受范围但打开报告时没有相关信息。当我打开没有日期范围方法的报告时，它会向我显示我的所有记录。我认为由于某种原因，日期范围形式不是从现场跟进中拉出来的。我希望你能够明白。我该怎么做才能解决这个问题，或者我可以采用另一种方法来创建这个日期范围报告？

Hello I have attempted to create a date range report from a query called qrycustomerinformation. The field that contains the value of my date is called Followup. When i run a report on this it is fine. But I have decided I would like to pull this report for a specific date range. Ive attempted to use the method on allen brownes page http://allenbrowne.com/casu-08.html. I would like to also mention the followup field also uses this code to generate a date three months from the date the record is entered =DateAdd("m",3,[Date]). When enter a date range for the report it accepts the range but opens the report with no information on it. When I open the report without the date range method it show me all my records just fine. Im thinking that for some reason that the date range form is not pulling from the field followup. I hope you can understand. What can I do to fix this or is there another method that I can go about creating this date range report?

推荐答案

我想我只是遇到了同样的问题你现在有。看看这个并告诉我它是否与你想做的相似。

http://www.thescripts.com/forum/showthread.php?p=2771747#post2771747


Scotter

Hi, I think I just had the same issue you are having now. Look at this and tell me if its similar to what your trying to do.
http://www.thescripts.com/forum/showthread.php?p=2771747#post2771747

Scotter

我正在尝试做类似的事情，但是当我提交报告时，它们会出现空白。

I am trying to do a similiar thing, but when I pull my reports they come up blank.

好的，那么您的报告是基于查询正确的吗？你是把日期放在一个表格然后运行报表，还是没有？


如果你正在使用一个表单，你是否正在做同样的事情你在哪里建立你的SQL表格？什么是你的查询SQL？


Scotter

Ok, so your report is based on a query correct? And are you putting the date into a form and then runing the report, or no?

If you are using a form, are you doing the same kinda thing where your building your SQL within the form? and what is your querries SQL?

Scotter

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