Trying to discern buying patterns.
Database has individual fiels for:
InvoiceID (number - unique)
CustomerID (number - unique)
An individual customerID may have hundreds of invoices, each with a DatePosted, and InvoiceID.
It is easy through relationships to find date of first purchase and date of last purchase.
What I'm having trouble wrapping my (pointy) head around is:
"How do I find the purchase date of the invoice immediately prior to the last purchase date?"
Any comments, as always, welcomed.