如何在查询iif标准中显示所有值？ [英] How to show all values in a query iif criteria?

问题描述

你好论坛！


我有这个问题：


我有一个使用这个标准的列的查询：

Hello forum!

I have this question:

I have a query with a column that uses this criteria:

展开 | 选择 | Wrap | 行号

推荐答案

我也对这个问题很感兴趣，因为我来了几天前同样的问题。我在查询条件字段中有一个IIF语句，无论我如何安排它，它都无法工作。经过几个小时的讨论，我最终重新处理了我的表单以解决问题。

I''m also interested in a good answer to this, since I came upon the same problem a few days ago. I had an IIF statement in a query Criteria field, and it just wouldnt work no matter which way I arranged it. After a few hours of messing around with it, I ended up re-working my form to get around the query.

你好论坛！


我有这个问题：


我有一个使用这个标准的列的查询：

Hello forum!

I have this question:

I have a query with a column that uses this criteria:

展开 | 选择 | Wrap | 行号

您需要替换Like *;使用返回结果的函数而不是函数的标准。如果客户是<> 3，则fCustomerType（）返回一个值。然后你需要一个类似的函数来在客户= 3时返回一个值。


查看fCustomerType（）函数，并可能根据第一个或帖子创建第二个函数它在这里让我们看到。更多信息无法更明确。


IE - IIf（fCustomerType（）<> 3，fCustomerType（），fCustomerTy pe3（））

You need to replace the "Like *" with a function that returns results not the criteria of the function. If fCustomerType() returns a value if customer is "<>3" then you need a similar function to return a value when customer "=3".

Look at the fCustomerType() function and possibly create a 2nd one based on the 1st one or post it here for us to see. Can''t be more definitive with more info.

IE - IIf(fCustomerType()<>3,fCustomerType(),fCustomerTy pe3())

谢谢。


在我的应用程序中，如果fCustomerType（）= 1，那么查询应该只显示带有1值的记录，如果fCustomerType（）= 2，它应该只显示带有''2''值的记录，如果fCustomerType（）= 3，它应该显示所有记录。


我应该用fCustomerType3（）的值来表示所有值？

Thanks.

In my application, If fCustomerType()=1 then the query should show only the records with ''1'' values, if fCustomerType()=2 it should show only the records with ''2'' values, if fCustomerType()=3 it should show all records.

By what value of fCustomerType3() should I represent all values?

这篇关于如何在查询iif标准中显示所有值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！