查询的标准 [英] Criteria for a query

问题描述

我知道我应该能够绕过这个但是由于某些原因我的大脑今天不在那里。

这是我在设置字段标准时需要帮助的查询：

I know that I should be able to wrap my head around this but for some reason my brain isn?t there today.
This is my query to which I need help in setting the fields criteria:

展开 | 选择 | Wrap | 行号

推荐答案

您要回答的问题或疑问是什么？

用简单的英语，你希望找到/选择什么？

What is the question or query you''re trying to answer?
In plain english, what are you hoping to find/select?

数据库是关于维护公寓楼的套房。我给出的这个例子只有一个表。我在套房里有几个不同的区域。例如：客厅桌子，厨房，桌子，浴室桌子等。当我执行条件报告时，套件中的每个项目都被赋予等级：良好，公平，差，染色，破碎，修复等。


我想要的是当我输入条件报告的数据时，所有需要修复的项目。或R或R。被拔出所以我可以创建关于该项目的工作单。

The database is about maintaining suites in an apartment building. This example that I gave is only one table. I have several for different area in the suite. Example: Living room table, kitchen, table , bathroom table and so on. when I perform a condition report each item in the suite is given a grade: Good, Fair, Poor, Stained, Broken, Repair ect.

what I want to have is when I finished entering the data for a condition report, all item that requires "repair" or "R" to be pulled out so I can create a work order about the item.

好的，另一个问题。为什么你使用左连接？

任何字段* IN都可以有一个R你要选择的epair - 对吗？

Ok, another question. Why do you use Left Join?
Any o fthe fields *IN could have a "R" epair which you want to select -- right?

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