计算字段生成意外的参数提示 [英] Calculated field generates unexpected parameter prompt

问题描述

我有下面的计算字段，它本身运行良好。但是，当我将选择条件（3）放入查询时，我得到这些无法解释的参数提示。我在Windows XP上运行Access 2002。有什么想法吗？


（（Nz（[VotingHistory1]，0）+ Nz（[VotingHistory2]，0）+ Nz（[VotingHistory3]，0）+ Nz（ [VotingHistory4]，0）+ Nz（[VotingHistory5]，0））= 3）

解决方案

你究竟想用这个计算做什么？它是在查询中使用If ... Then构造的一部分还是在其他东西中使用？


我们需要更多解释，或者最好是实际看到你的SQL代码。正如我今天告诉其他人的那样，Carnac the Magnificent不再来这个论坛了！


Linq; 0）>

< blockquote class =post_quotes>
但是，当我将选择条件（3）放入查询时，我得到这些无法解释的参数提示。

原因不明，但更重要的是，未共享。


您是否认为错误消息可能有助于指示问题是什么你的其余解释并没有告诉我们什么，所以我们只是希望错误信息可能会给我们一个线索。如果没有它，我们就会试图读懂你的想法 - 但正如Linq已经说过的那样：

Carnac the Magnificent不再来这个论坛了！

我以为我在分享相关信息。抱歉。以下是参数提示所说的内容：

输入参数值


"投票历史1"

这是整个SQL代码：

展开 | 选择 | Wrap | 行号

I have the calculated field below, which runs fine by itself. When I put a selection criteria (3) into the query, however, I get these unexplained parameter prompts. I''m running Access 2002 on Windows XP. Any thoughts?


((Nz([VotingHistory1],0)+Nz([VotingHistory2],0)+Nz([VotingHistory3],0)+Nz([VotingHistory4],0)+Nz([VotingHistory5],0))=3)

解决方案

What exactly are you trying to do with this calculation? Is it being used as part of a If...Then construct in the query, or in something else?

We either need more explanation or, preferably, to actually see your SQL code. As I told someone else today, Carnac the Magnificent doen''t come to this forum anymore!

Linq ;0)>

When I put a selection criteria (3) into the query, however, I get these unexplained parameter prompts.

Unexplained, but more importantly, unshared.

Does it not occur to you that the error message may help to indicate what the problem is. The rest of your explanation doesn''t tell us anything much so we''re just hoping the error message might give us a clue. Without it we are left trying to read your mind - But as Linq said already :

Carnac the Magnificent doen''t come to this forum anymore!

I thought I was sharing the relevant info. Sorry. Here is what the parameter prompt says:
"Enter Parameter Value"

"Voting History 1"

Here is the entire SQL code:

Expand|Select|Wrap|Line Numbers

这篇关于计算字段生成意外的参数提示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！