Forgot a couple of little things!!

SELECT T1.[Item codes], SUM(T1.[qty units]) AS TotalUnits, MAX(P.Prices) AS
PricesMaxDate
FROM MyTable T1
INNER JOIN (
SELECT T2.[Item codes], MAX(T2.[prices]) AS Prices
FROM MyTable T2
WHERE T2.[proce dates] = (
SELECT MAX(T3.[proce dates])
FROM MyTable T3
WHERE T3.[Item codes] = T2.[Item codes])
GROUP BY T2[Item codes]) P ON P.[Item codes] = T1.[Item codes]
GROUP BY T1.[Item codes]


"Paul" <pchronos (AT) hotmail (DOT) com> wrote