That unfortunatly didnt work - here is a screenshot of the output and the query that I used, based on your suggestion. What I'd like to do is get the last day of the month from my daily data series and the corresponding px_last number - am I wrongly setting up the query?
THanks for your help with this jzwp11
Code:
SELECT DateAdd("d",1,DateSerial(Year([Period]),Month([Period]),1))-1 AS MonthEnd, px_last as Price
FROM tbl_H15T10Y
GROUP BY DateAdd("d",1,DateSerial(Year([Period]),Month([Period]),1))-1, px_last;