If row value changes

[#1]

Hello everybody,

I'm new here and this is my first question.

Im trying to get a moving MAX value for the colummn MENGE which should change, when the text value on the colummn ARTNR also changes. I'm looking for the MAX MENGE value for each article and this value should be displayed and repeated for all the rows with the same ARTNR.

Here you have the structure of my data. It ´d be very glad if you could help me.

Thank you very much

Urdru.

ARTNR	LHMNR	SEKTORNR	MENGE
			-
000.3-60-0000.5-L	43017	2	3
000.3-60-0000.5-L	43030	2	9
000.3-60-0002.0-L	41699	1	3
000.3-60-0003.0-L	42092	2	1
000.8-42-2-R	42646	2	6
000.8-42-8-L	42724	1	3
000.8-42-10-L	43016	2	15
000.8-42-10-R	42591	1	7
000.8-42-16-R	42325	1	5
000.8-42-24-R	43064	2	5
000.8-42-40-L	42634	2	16
000.8-42-40-R	42608	2	1
000.8-42-50-R	42839	1	2
000.8-42-72-R	42965	2	3
000.8-42-100-L	42605	2	16
000.8-60-4-L	41835	1	8
000.8-60-6-L	42107	2	3
000.8-60-8-R	42280	2	10
000.8-60-10-L	42782	2	11
000.8-60-16-R	41997	3	3
000.8-60-24-L	41813	4	1

[swuehl · Accepted solution]

Maybe adding to your script:

Left Join (YourTable) LOAD ARTNR, max(Menge) as MaxMenge resident YourTable group by ARTNR;

[#3]

Thank you very much swuehl for you quick and certain answer. It runs perfectly.

MfG

Urdru