distinguishing years

[alh1002]

I am summarizing daily table into monthly and yearly tables

the following query works within a given year: but if you multiple years it fails (i.e. it doesn't distinguish between Suggestions?

SELECT A.ladder_date, A.BOM, A.NAV, A.gMTDRT, A.gMTDPER
FROM dailySummary AS A INNER JOIN (
SELECT Month([ladder_date]), MAX([ladder_date]) AS LastDay FROM dailySummary GROUP BY Month([ladder_date])
) AS L ON A.ladder_date = L.LastDay

 

[JerryKlmns]

You should group by year also, not only month

SELECT A.ladder_date, A.BOM, A.NAV, A.gMTDRT, A.gMTDPER
FROM dailySummary AS A INNER JOIN
(SELECT Year([ladder_date]), Month([ladder_date]),
MAX([ladder_date]) AS LastDay
FROM dailySummary
GROUP BY Year([ladder_date]), Month([ladder_date])) AS L
ON A.ladder_date = L.LastDay

But this post should be in forum701.