如何在查询中添加Criteria'rows'？ [英] How to add Criteria 'rows' in a Query?

问题描述

我想在不使用VBA的情况下进行选择查询，只需使用向导即可。我发现的问题是我需要做更多的OR。陈述比标准的''行'。有没有办法添加标准的新行？

我有9行要做OR声明，但我需要做10OR声明。


Cristina

Hi,

I want to do a Select Query without VBA, just using the wizard. The problem that I find is that I need to do more "OR" statements than ''rows''of criteria. Is there a way to add new ''rows''of criteria?
I have 9 rows to do "OR" statement, but I need to do 10 "OR" statements.

Cristina

推荐答案

您只需输入或或在标准中。从技术上讲，您可以在一行标准中执行所有9个或更多OR。这实际上更好，因为如果您测试了多个列，向导的行为方式。它可能无法按照您认为的方式组合列上的测试。


或者您可以右键单击向导的上半部分并进入SQL模式并键入。在看到前9个SQL的格式后，您将了解如何添加X更多OR。这就是我们中有多少人学会了编写SQL代码。


Jim

You can just type "or" in the criteria. Technically you could do all 9 or more ORs in one row of criteria. That actually is better because of the way the wizard acts if you have more than one column being tested. It may not combine the tests on the columns the way you think it will.

Or you could just right-click in the upper half of the wizard and go into SQL mode and type away. After you see the format of the SQL for the first 9 you''ll understand how to add X more ORs. That''s how many of us learned to code SQL.

Jim

如果你的逻辑中有那么多OR，那么'' sa（非常）很有可能你没有正确地设计它。


你究竟想做什么？


为什么不在问题中发布你当前的一些SQL来说明你想说的是什么？

If you have that many ORs in your logic then there''s a (very) good chance that you''re not designing it correctly in the first place.

What exactly are you trying to do?

Why not post some of your current SQL in the question to illustrate what you''re trying to say?

你好NeoPa，

这里有SQL：

Hi NeoPa,

Here you have the SQL:

展开 | 选择 | Wrap | < span class =codeLinkonclick =LineNumbers（this）;>行号

这篇关于如何在查询中添加Criteria'rows'？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！