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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max Function in a query 2
Find max date on a form 3
Percent change 4
Building a select query 2
MAX DATE 7
Min/Max Dates and Group By 2
Most recent date prior to test date. 1
Max; Min & Dates 2

Back
Top