1 of 1 people found this helpful
Yes it is possible.
If you create a self-relationship sorted by ascending date to the customer you can view all related records. you can then calculate the most recent and second most recent transactions.
My I suggest that you need to have a Purchases table which is related to the customer table. This would ensure that the customer is only entered once but can have many purchase transactions. You must be unnecessarily entering customer details each time instead of reusing existing master data.