为什么这个简单的查询不会运行？ [英] Why won't this simple query run?

问题描述

使用Access 2013。

Using access 2013.

我有一个名为'Claim_No'的短文本字段的表，每个索赔号都是11个字符。由于格式问题，我需要从字段中删除最后2个字符。我创建了另一个名为'claimno'的短文本字段，我正在尝试运行
以下查询，使用Claim_No字段中的前9个字符填充它：

I have a table with a short text field called 'Claim_No' and every claim number is 11 characters. Due to formatting issues I need to remove the last 2 characters from the field. I created another short text field called 'claimno' and I am trying to run the following query to populate it with the first 9 characters from the Claim_No field:

UPDATE Payment_Register SET Payment_Register.claimno =左（[Payment_Register]。[Claim_No]，9）;

UPDATE Payment_Register SET Payment_Register.claimno = Left([Payment_Register].[Claim_No],9);

也尝试没有括号：

UPDATE Payment_Register SET Payment_Register。 claimno = Left（Payment_Register.Claim_No，9）;

UPDATE Payment_Register SET Payment_Register.claimno = Left(Payment_Register.Claim_No,9);

但是，当我尝试运行查询时，我会收到提示输入Claim_No值。

我究竟做错了什么？我已经成功运行了数百个类似的查询，但出于某种原因，我看不到，这将无法运行。

However, when I try to run either query I get a prompt to enter the Claim_No value.
What am I doing wrong? I have run hundreds of similar queries successfully, but for some reason that I can't see, this won't run.

提前感谢您的帮助。  --Fred

Thanks in advance for any help.  --Fred

推荐答案

嗨Fred，

如果收到Claim_No的提示，那么也许字段名称的拼写不正确。

If you are getting prompted for Claim_No, then perhaps the spelling of the field's name is not correct.

只是一个想法......

Just a thought...

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