[MS_AccessPros] Query to select the second number in a series of number

 

Would any of you please help me to write this queries:

 have a table that has 3 columns: Col A: ticker, Col B: InputDate, Col C: Comment. The purpose of the table is to keep comments posted on a particular stock.

I can get the latest date by using the MAX function or the oldest date by using MIN function. 

But is there a way to get the second latest date? or third latest date?

Thank you in advance for your help!

Tim

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___