查询参数/功能 [英] query parameters/functions

问题描述

我对查询参数有疑问：

我正在尝试过滤最后有特定文本标记的项目的主数据。


我正在尝试使用''Right（[category]，5）''作为表达式的一部分但是我总是ge #Error，即使我试图得到5个最右边的角色。


是否有类似''喜欢'的东西......"''，它适用于文本的后端？或者我是想从错误的方向接近这个。


我正在使用Access''97


提前致谢

I''ve got a question regarding query parameters:
I am trying to filter the master data for items whivh have a specific text sting at the end.

I was experimenting with using ''Right([category],5)'' as part of the expression but I always ge #Error as a result, even if I try to get the 5 right-most characters.

Is there something similar to ''Like "...."'', which works fro the back end of the text? Or am I trying to approach this from the wrong direction.

I am using Access ''97

Thanks in advance

推荐答案

您的方法是正确的。你可以发布完整的SQL吗？

Your approach is right. Can you post your full SQL?

SQL代码只试图显示字段的最后3个字符：


SELECT Right（[claimid] ]，3）AS Expr1

来自claim_master;


这里我得到了#Error


如果我想过滤记录的结果，其中字符串的结尾是仅而不是我正在尝试使用的代码是：


SELECT claim_master.claimid

FROM claim_master

WHERE（（正确（[claimid]，5）=" only）"））

GROUP BY claim_master.claimid;


如果我尝试运行此查询我收到一条Waning /错误消息：此表达式键入错误，或者它太复杂而无法评估...


谢谢

the SQL code for only trying to display teh last 3 characters of field:

SELECT Right([claimid],3) AS Expr1
FROM claim_master;

Here i get #Error as a result

If I want to filter the results for records, where the end of the string is "only)" the code that I''m trying to use would be:

SELECT claim_master.claimid
FROM claim_master
WHERE ((Right([claimid],5)="only)"))
GROUP BY claim_master.claimid;

if I try to run this query I get a Waning/error message: "This expression is typed incorrectly, or it is too complex to be evaluated ..."

Thanks

你可以使用

展开 | 选择 | Wrap | 行号

这篇关于查询参数/功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！