G
Guest
Hi..I am a newbie....
I am trying to retrieve the second most recent date data from a query....Can
someone please help me.....
Here is the SQL for the most recent date info.....
SELECT Focus.CompanyName, Max(Focus.[End Date]) AS [MaxOfEnd Date]
FROM Focus
GROUP BY Focus.CompanyName;
Thank you,
Jay
I am trying to retrieve the second most recent date data from a query....Can
someone please help me.....
Here is the SQL for the most recent date info.....
SELECT Focus.CompanyName, Max(Focus.[End Date]) AS [MaxOfEnd Date]
FROM Focus
GROUP BY Focus.CompanyName;
Thank you,
Jay