无效的过程调用错误 [英] Invalid Procedure Call error

问题描述

我在查询中收到错误提示''无效过程调用''。我的查询非常简单。我只是从另一个从表中获取数据的查询中获取数据。


SELECT

Last（ProperCase（qryCustomerInfo。[Last Name]））< br $>
来自qryCustomer


qryCustomer工作正常并返回所有必需的行但我不知道为什么获取姓氏导致问题。请帮忙。

Hi,
I am getting the error saying ''Invalid Procedure Call'' in my query. My query is very simple. I am just getting data from another query which is getting data from a table.

SELECT
Last(ProperCase(qryCustomerInfo.[Last Name]))
FROM qryCustomer

The qryCustomer is working fine and returning all the required rows but I don''t have any idea why getting the last name is causing problem. Please help.

推荐答案

你好。

你可能想要这样的东西：

Hello.
You probably want something like this:

展开 | 选择 | Wrap | 行号

你从哪里获得ProperCase功能？您是否尝试在没有它的情况下运行查询。

Where did you get the ProperCase function from? Have you tried running the query without it.

如果我使用ProperCase（qryCustomerInfo。[Last Name]），它可以正常工作。如果客户的姓氏为ABC，则将其转换为Abc。但是，当我向查询添加Last时，它会导致问题。我认为数据存在一些问题。但我不知道它能是什么。


如果我使用Last（StrConv（qryCustomerInfo。[Last Name]，3）），那么它也说无效的过程调用。我不知道到底发生了什么。请帮帮我。

If I use ProperCase(qryCustomerInfo.[Last Name]), it works fine. If a customer''s Last Name is ABC the it is converted to Abc. But when I add Last to the query it is causing problem. I think there is some problem in the data. But I don''t know what can it be.

If I use Last(StrConv(qryCustomerInfo.[Last Name],3)) then also it is saying Invalid procedure call. I don''t know what is really happening. Please help me.

这篇关于无效的过程调用错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！