在Access REPORT中使用参数查询 - 额外参数是什么？ [英] Using parameter queries in an Access REPORT--what is the extra parameter?
问题描述
我正在尝试我的第一份Access报告。它基于两个参数查询（开始日期，结束日期）。当我使用报告向导并单击查看报告时报告提示我两个查询。大！但是，当我关闭它并重新运行报告时，它会提示我输入第三个参数：HOTSTICK_FAILURE.DATE_ENTERED。上半部分是表名;下半部分是表字段名称。
此报告的查询基于开始日期和结束日期之间总计的总和...所以显然我不想指定输入的日期。在我的查询中...即使我知道它来自哪里。
我做错了什么，或者我能做些什么来使这个工作像我的查询一样？我确实在Microsoft的帮助中看到了一些内容，其中包括使用表单将值传递给报表查询...它涉及一些VBA代码，我不理解所有代码所以我不愿意用它。有更简单的方法吗？
我是一个新的Access用户，所以不要以为我什么都知道！ :-)
在此先感谢Danica
I am trying my hand at my first ever Access report. It is based on a two parameter query (start date, end date). When I use the report wizard and click "view report" the report prompts me for the two queries. Great! However, when I close it and re-run the report, it prompts me for a third parameter: HOTSTICK_FAILURE.DATE_ENTERED. The first half is a table name; the second half is a table field name.
The query this report is based off of sums up totals between the start date and end date...so clearly I don''t want to specify a "date entered" in my query...even if I DID understand where it was coming from.
What am I doing wrong, or what can I do to make this work just like my query? I did see something in the help on Microsoft that included using a form to pass values to a report query...it involved a bit of VBA code, and I don''t understand all of the code so I''m reluctant to use it. Is there an easier way?
I am a new Access user, so don''t assume I know anything!! :-)
Thanks in advance, Danica
推荐答案
你能发布你的查询代码。
这里是如何得到它以防你不知道！
说明是访问2003年。如果你使用2007年可能会有所不同
1）设计查询
2）在viey菜单中选择SQL View
3）将出现一个窗口，其中包含实际的SQL代码您的查询
4）突出显示所有SQL代码并将其复制
5）将其粘贴到帖子中
Can you post your query code.
Here''s how to get it in case you don''t already know!
Instructions are for access 2003. It may be different if you are using 2007
1) Design the query
2) In the viey menu select "SQL View"
3) A window will appear with the actual SQL code for your query
4) Highlight all of the SQL code and copy it
5) Paste it into a post
我确实在Microsoft的帮助中看到了一些内容，其中包括使用表单将值传递给报表查询...它涉及一些VBA代码，我不明白所有代码所以我不愿意使用它。
I did see something in the help on Microsoft that included using a form to pass values to a report query...it involved a bit of VBA code, and I don''t understand all of the code so I''m reluctant to use it.
不要害怕尝试新的东西。
制作数据库副本并在副本中试用。
这样你就不会打破原始的。
请注意，不要在包含实时数据的表格上进行实验。
这将确保您的快速进步，特别是如果您结对了
你的实验
首先搜索类似于你的问题的答案
其次问一个直接的问题，如果你找不到答案。
Don''t be afraid to experiment with something new.
Make a copy of your database and try it in the copy.
That way you can''t break the orriginal.
Just be careful that you dont experiment on tables containing live data.
This will ensure rapid progress for you, especially if you couple
your experiments by
first seaching for answers to questions similar to yours
secondly asking a direct question if you can''t find an answer.
这篇关于在Access REPORT中使用参数查询 - 额外参数是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
