Get Date Before Max Date

Joined
May 15, 2008
Messages
2
Reaction score
0
Any help is appreciated! I'm using MS Access 2003. I don't know if this is even possible but I need to get the date before the Max Date. I got the MAX date for each userID by using :
SELECT tblMain.userID, Max(tblMain.Date) AS [Max Date]
FROM tblMain
GROUP BY tblMain.userID;

If the MAX date is 10/30/2007..the date before that could be anything...for example, it could be 9/26/2005.

Any way to get the previous rows BEFORE MAX(DATE)?

Thank you,
Elizabeth E.
 
Back
Top