Hi,
I'm building a report that uses a non-unique key to identify customer purchases (i.e. Customer No (Non-Unique), Purchase No (Unique), Purchase Type, Purchase Date etc.).
The report is on one customer number, and is supposed to list down the page 'Most Recent Purchase' at the top with all the details (Purchase Type, Purchase Date etc.) and then 'Previous Purchase 1', 'Previous Purchase 2', 'Previous Purchase 3' and so on.
i.e. Customer No.: 50xxxx
Most Recent Purchase
Purchase Date: 4/11/2007
Purchase Type: Standard
Item: Whatsit
RRP: $2.00
Previous Purchase 1
Purchase Date: 17/10/2007
Purchase Type: Standard
Item: Whosit
RRP: $1.40
Previous Purchase 2...etc.
How would I do this?
I'm building a report that uses a non-unique key to identify customer purchases (i.e. Customer No (Non-Unique), Purchase No (Unique), Purchase Type, Purchase Date etc.).
The report is on one customer number, and is supposed to list down the page 'Most Recent Purchase' at the top with all the details (Purchase Type, Purchase Date etc.) and then 'Previous Purchase 1', 'Previous Purchase 2', 'Previous Purchase 3' and so on.
i.e. Customer No.: 50xxxx
Most Recent Purchase
Purchase Date: 4/11/2007
Purchase Type: Standard
Item: Whatsit
RRP: $2.00
Previous Purchase 1
Purchase Date: 17/10/2007
Purchase Type: Standard
Item: Whosit
RRP: $1.40
Previous Purchase 2...etc.
How would I do this?
