How to select data for the most recent two date entries

tamaragreen

Forums

Hi, I have a dataset that has multiple entries for a particular customer, ordered by date. I'm trying to return all data for each customer based on the last two date entries - doing it for the last and first dates is easy enough, but I'm struggling on the last two date entries. Any suggestions at all are very welcome! Otherwise I'll end up having to run the whole thing in sequel, which I'd rather not do..
 
ThanksTammy

tamaragreen Tue, 04/10/2018 - 04:18

Nevermind - I've sorted it! Was overcomplicating things and a top records extraction proved to be perfect!