报告问题 [英] Report Question

问题描述

我正在尝试撰写报告。

我有一个查询从表中选择1条记录。

表中有20或30个字段全部是\没有。


我希望报告中的字段只有Yes，所以看起来就像是。



报告名称

产品？水？

----------------------

氧气

氢气


报告结束

I?m trying to write a Report.
I?ve a query that selects 1 record from the table.
The Table has 20 or 30 fields all Yes\No.

I want the report to only have the fields that are Yes so it would look something like.


Report Name
Product ?WATER?
----------------------
Oxygen
Hydrogen

End of report

推荐答案

我有点困惑至于你在问什么。但是，如果你想确定如何只引入是字段。在查询中，您需要做的就是使用是/否的字段标准，写入是。

I am a little confused as to what you are asking. But if you want to determine how to only bring in the field that says "Yes" in a query, all you need to do is in the criteria for the field with yes/no, write yes.

如果我正确地描绘了表格，那么你有20到30列的与你列出的水相似的名字？


如果是这样，这是一个典型的电子表格设计，不适合在关系数据库中使用。


使用此假设，您可能会对每个字段的Where条件设置为Yes进行查询。由于几个原因，这对你来说不会很好，首先是它会返回零记录，或者很少有记录，因为很少有元素会有所有的'！' >

可视化关系数据库的更好设计的一种方法是将宽和浅与狭窄和深相比较。电子表格通常很宽，但相当浅。换句话说，列数与记录数更相似。设计良好的数据库表通常具有更少的列，但记录更多。


这是链接到一篇关于数据库规范化和表结构的好文章，值得一读。


问候，

Scott

If I picture the table correctly, you have 20 to 30 columns with the names similar that what you listed for Water?

If so, this is a typical spreadsheet design that doesn''t lend itself well to use in a relational database.

Using this as an assumption, you will likely have a query with Where criteria set to Yes for every field. This isn''t going to work very well for you for several reasons, first of which is that it will return zero records, or very few records, since there are very few elements that will have ALL yes''s!

One way to visualize a much better design for a relational database is to think of ''wide'' and ''shallow'' versus ''narrow'' and ''deep''. A spreadsheet is typically wide, yet fairly shallow. In other words the number of columns is more comparable to the number of records. A well designed database table usually has far fewer columns, but far more records.

Here is a link to a good article on Database Normalisation and Table Structures that would be well worth reading.

Regards,
Scott

我对你的要求感到有点困惑。但是，如果你想确定如何只引入是字段。在查询中，您需要做的就是使用是/否的字段标准，写入是。

I am a little confused as to what you are asking. But if you want to determine how to only bring in the field that says "Yes" in a query, all you need to do is in the criteria for the field with yes/no, write yes.

这不是很正确（尽管所有诚实的帮助都值得赞赏）。


斯科特说，你真的需要一个规范化的数据库来轻松处理这个问题。

This isn''t quite right (though all honest attempts to help are appreciated).

A Scott says, you really need a normalised database to handle this easily.

展开 | 选择 | Wrap | 行号

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