删除多余的访问字段单元

本文是小编为大家收集整理的关于删除多余的访问字段单元的处理/解决方法，可以参考本文帮助大家快速定位并解决问题，中文翻译不准确的可切换到English标签页查看源文。

中文
English

问题描述

我有下表，其中包含三个主要字段 Name_2010、Name_2011 和 Name_2012，它们需要集成为 Name_Final.

coven

我使用下面的查询仅选择每行三个字段中的一个特定成员，但目前它无法按预期工作，因为它无法识别冗余单元格.

SELECT
  IIf(Name_2010 In (Name_2011, Name_2012), '', Name_2010) 
  AS N1,
  IIf(Name_2011 In (Name_2010, Name_2012), '', Name_2011) 
  AS N2,
  IIf(Name_2012 In (Name_2010, Name_2011), '', Name_2012) 
  AS N3
  FROM Table1;

在给定当前表的情况下，我应该使用什么查询来实现 Name_Final?

推荐答案

SELECT ID, N1 &
  IIf(N2 <> N1, N2, '') &
  IIf((N3 <> N2) And (N3 <> N1), N3, '') AS Name_Final
FROM
  (SELECT ID, Nz(Name_2010) AS N1, Nz(Name_2011) AS N2, Nz(Name_2012) AS N3
   FROM Table1) AS T
ORDER BY ID;

ORDER BY 子句是为了它所说的，而不是作为"Name_Final"计算的一部分.

本文地址：https://www.itbaoku.cn/post/597330.html

百度翻译此文有道翻译此文

问题描述

Continued from Combine Access fields into one field given two queries

I have the table below with three main fields Name_2010, Name_2011 and Name_2012 and they need to be integrated as Name_Final.

coven

I used the query below to select only a particular member of the three fields per row but currently it does not work as intended as it does not recognize redundant cells.

SELECT
  IIf(Name_2010 In (Name_2011, Name_2012), '', Name_2010) 
  AS N1,
  IIf(Name_2011 In (Name_2010, Name_2012), '', Name_2011) 
  AS N2,
  IIf(Name_2012 In (Name_2010, Name_2011), '', Name_2012) 
  AS N3
  FROM Table1;

What query should I use to achieve Name_Final given my current table?

推荐答案

SELECT ID, N1 &
  IIf(N2 <> N1, N2, '') &
  IIf((N3 <> N2) And (N3 <> N1), N3, '') AS Name_Final
FROM
  (SELECT ID, Nz(Name_2010) AS N1, Nz(Name_2011) AS N2, Nz(Name_2012) AS N3
   FROM Table1) AS T
ORDER BY ID;

The ORDER BY clause is for what it says, rather than being a part of the 'Name_Final' calculation.

上一篇：将数据库从一个领域转移到另一个领域

下一篇：无法在Sql Server中运行分析函数