Not directly what you want but it should work. In this query you need a column [DISTRIKT] , [ABTEILUNG] and [TEXT]. The [TEXT] of your Areas <5m² must be empty. The [TEXT] of your areas >=5m² must be filled. Run the query twice or more to fill all areas. A query of Tim (tjhb): ____________________________________________ --SQL --In allen Nichtholzbodenflächen wird das Feld [TEXT] --mit der TEXT des größten Bestandes aus derselben Abteilung gefüllt --Bezeichnung des DRAWINGS ändern ! UPDATE -- start of (3) - rearrange WEFL with corrosponding first NeighborWEFL ( SELECT [D14].[TEXT] AS [TEXT], [NeigborWEFL] FROM -- Start of (2) - aggregate [ID], First NeighborWEFL from ordered list ( SELECT [ID], First([NeigborWEFL]) AS [NeigborWEFL] FROM -- Start of (1) - oder list of neighbours ( SELECT [D11].[ID], [D12].[TEXT] AS [NeigborWEFL], CASE WHEN [D11].[DISTRIKT] = [D12].[DISTRIKT] AND [D11].[ABTEILUNG] = [D12].[ABTEILUNG] THEN 0 WHEN [D11].[DISTRIKT] = [D12].[DISTRIKT] THEN 1 WHEN [D11].[ABTEILUNG] = [D12].[ABTEILUNG] THEN 2 ELSE 3 END AS [Weight], [D12].[AREA (I)] AS [Area] FROM [119_36_wefl] AS [D11] INNER JOIN [119_36_wefl] AS [D12] ON Adjacent([D11].[ID],[D12].[ID]) WHERE TRIM([D11].[TEXT]) = "" AND TRIM([D12].[TEXT]) <> "" ORDER BY [ID],[Weight],[Area] DESC ) -- END OF (1) GROUP BY [ID] ) AS [D13] -- END OF (2) JOIN [119_36_wefl] AS [D14] ON [D14].[ID] = [D13].[ID] ) -- END OF (3) SET [TEXT] = [NeigborWEFL]
http://www.thegisservicesector.de |