为什么我的查询会多次询问每个参数？ [英] Why does my query ask multiple times for each parameter?

问题描述

我有以下查询：

I have the following query:

展开 | 选择 | Wrap | 行号

推荐答案

没理由我可以见苏。你是原生运行的吗？或者是其他对象的 .RecordSource ？

No reason I can see Sue. Are you running it natively? Or is it the .RecordSource for some other object?

如果您使用此查询作为报告的记录源，它将在您询问参数值时预览报告。当你从预览更改为打印时，它将再次询问参数值。

If you are using this Query as Record Source for your Report it will ask for the parameter values when you preview the Report. When you change from preview to print it will ask for the parameter values again.

我遇到了这个问题并通过将"解决了。围绕我希望在查询的设计视图中显示的值。现在它没有要求参数。希望这可能有用！

I had this problem and solved it by putting "" around the values I wanted to be shown in the design view of the query. Now it doesn''t ask for a parameter. Hope that is possibly helpful!

这篇关于为什么我的查询会多次询问每个参数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！