Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / May 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ChuckW - 19 May 2005 21:16 GMT
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,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.