Listing the last two times that someone has placed an order from u

[Guest]

Hi,

I have been doing a report called OpeningOrders where I do a Max by
transaction date and obtain the first time that someone purchased from us. I
then do a date a date restrictor and get everyone who has purchased from us
for the first time in the last 30 days. I am now trying to do something more
complex. I want to get the first two times that someone orders from us and
listing these on a report.

So if company A places an order for $400 on 5/1/05, and $300 on 5/2/05. I
want to list both of these transactions out. If they have placed more
orders, I don't want these listed. Is there a way to get the first two times
that someone has ordered from us chronologically.

Can someone help?

Thanks,

 

[Van T. Dinh]

Use the technique similar to those shown in Microsoft Knowledge Base
article:

http://support.microsoft.com/?id=210039

and

http://support.microsoft.com/?id=208822