- 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.
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.