生成报告/查询... [英] GENERATE report/query on the fly...

问题描述

我已经包含了我的代码片段。我正在尝试将结果输出到报表或查询。现在，由于我的DEBUG命令，我可以在即时窗口中看到我的结果。如何获取这些结果并动态创建报告/查询？在此先感谢任何帮助...它可能很简单，我只是看不到它！

.........


直到rs2.EOF

直到rs1.EOF

如果rs2！符号= rs1！符号然后

如果rs1！MarketPrice< ;> -5.25然后

Debug.Print rs1！LocateDate，rs1！Symbol，rs1！MarketPrice

''rs1.MoveNext

退出Do

否则

rs1.MoveNext

结束如果

否则

rs1.MoveNext

I have included a snip of my code. I am trying to output my results to a report or a query. Right now I can see my results in the immediate window due to my DEBUG command. how can I take these results and create a report/query on the fly? Thanks in advance for any help...its probably simple and I just can''t see it!!
.........

Do Until rs2.EOF
Do Until rs1.EOF
If rs2!Symbol = rs1!Symbol Then
If rs1!MarketPrice <> -5.25 Then
Debug.Print rs1!LocateDate, rs1!Symbol, rs1!MarketPrice
''rs1.MoveNext
Exit Do
Else
rs1.MoveNext
End If
Else
rs1.MoveNext

推荐答案

您不仅无法将这些结果推送到表单或报表，也无法访问表单或报表的基础数据。

我希望我错了，因为，就像你自己一样，我觉得它应该是可能的。

我多年来一直在尝试和关闭： - （


请有人反驳我。

Not only can you not push these results to a Form or Report, you can''t access the underlying data of a Form or report either.
I hope I''m wrong on this because, like yourself, I feel it should be possible.
I''ve been trying on and off for years though :-(

Someone contradict me please.

我是否只是将它们写入临时表，然后使用此表作为我的报告的记录集？

Am I let with just writing them to a temporary table and then using this table as the recordset of my report?

你需要这样的东西：

You need something like this:

展开 | 选择 | Wrap | 行号

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