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,

Signature
Chuck W
Van T. Dinh - 20 May 2005 00:59 GMT
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

Signature
HTH
Van T. Dinh
MVP (Access)
> Hi,
>
[quoted text clipped - 13 lines]
>
> Thanks,