查找唯一值ONE列 - 访问SQL [英] Find Unique Values ONE Column - Access SQL

问题描述

这个论坛上次非常有用，以为我会再试一次！


已经到了我看不到树林的地方了我觉得解决方案非常简单！


我有一个包含以下列的表：工作，工人姓名，星期几，费率，adj，总数和评论。


要了解表格的一部分，请参见下文：

展开 | 选择 | Wrap | 行号

解决方案

首先，你的标签le绝对没有正常化。我不知道如何在同一列中找到一份包含工作名称和工人姓名的表格。我不能提出建议，直到你先放下你的桌子，这是我最好的建议。


请看这个链接，了解如何规范你的桌子：

（30.2 KB，517 views）

This forum has been so helpful last time, thought I would give it another try!

Have gotten to the point where I can''t see the forest for the trees as I have the feeling the solution is quite simple!

I have a table with the following columns: job, name of the workmen, days of the week, rate, adj, total and comments.

To give an idea of how, a part of, the table looks like, please see below:

Expand|Select|Wrap|Line Numbers

解决方案

First, your Table is definitely not normalized. I don''t see how you can have a table with the name of the job and name of the workmen in the same column. I can''t advise on this until you square away your tables first, which is my best advice.

Please see this link for advice on how to normalize your tables:

Database Normalization

Hi Twinnyfo,

Thanks for helping me out again!

Sorry if I didn''t make it clear, the job number and workmen are two separate columns (I did try to insert some ''tabs'' in the example table, but they got deleted after posting).

Does this help at all?

Please find attached a screenshot of the database and the records I would like to have deleted

Attached Images

Example.jpg (30.2 KB, 517 views)

这篇关于查找唯一值ONE列 - 访问SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！