按多个字段中的数据分组 [英] Group by data found in multiple fields

问题描述

您好..


我有一份由兼职人员提交的各种日期可用性表。可用性选项是可用，早晨和可用选项。和不可用。


我想创建一个查询来计算可用，早上和不可用的数量。


我附上了表格的样本和所需的查询结果供你的建议。


谢谢

克拉伦斯

Hello..

I have a table of availability submitted by part-timers for various dates. The availability options are "Available", "Morning" and "Not Available".

I would like to create a query to count the number of Available, Morning and Not Available.

I have attached sample of the table and the desired query result for your advice.

Thanks
Clarence

Attached Images

GroupbyAvailability.jpg （123.7 KB ，101意见）

Attached Images

GroupbyAvailability.jpg (123.7 KB, 101 views)

推荐答案

我担心这是一个完美的例子不存储此类数据 - 包括主要原因的奖励说明。


我建议检查数据库规范化和表结构。我担心在某些情况下你只需要知道如何正确地做事，因为没有其他方式没有极度痛苦。你在其中遇到其中一个我很遗憾地说。


至少它让你有机会学习重要的东西，避免在以后的任何工作中出现这样的设计问题。

I''m afraid that''s a perfect example of how not to store such data - with a bonus illustration of the main reason included.

I recommend checking out Database Normalisation and Table Structures. I''m afraid there are certain situations where you just have to know how to do things properly as there''s no other way without extreme pain. You''ve hit on one of them here I''m sorry to say.

At least it gives you the opportunity to learn something important and avoid such design issues in any future work.

感谢您的建议。


数据是通过Google表格/表格以网格问题格式收集并导入MS Access。我希望我可以利用所收集的数据。

Thank you for your advice.

The data was collected via Google Form / Sheets in a grid question format and imported into MS Access. I was hoping I can utilize the data collected.

你可以做克拉伦斯，但存储的数据和显示的数据往往是完全不同的动物。


我建议您将数据作为第一步导入临时（或保留）表。导入后运行（或某些）查询以将数据转换为旨在正确保存数据的表。正确设计的表格为您提供了更多的处理范围和显示您的数据，这样您就不会被这些限制所束缚。

You can do Clarence, but stored data and displayed data are often completely different animals.

I would suggest that you import the data as a first step into a temporary (or holding) table. Once imported run a (or some) query to convert the data into tables designed to hold it properly. Properly designed tables give you much more scope to process and display your data, such that you won''t be held up by such limitations.

这篇关于按多个字段中的数据分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！