finding first records only

C

ckitzman

Registered User.
Local time
Yesterday, 22:21
Joined
Sep 15, 2006
Messages
13
lots of customers. lots of orders. i need to query for the first order of each customer only. thoughts?
 
How about the Min() function based on the order date. Grouped by customer.

Col
 
You must log in or register to reply here.

Similar threads

D
Solved Appending records into history table of changes made to customer info
Replies
4
Views
267
Ken Sheridan
Ken Sheridan
asteropi
Solved Report/Query won't print my results
Replies
13
Views
460
Gasman
Gasman
M
Query with top 15 sorted ascending
Replies
4
Views
495
GPGeorge
GPGeorge
H
Solved Query for the balance stock material
Replies
8
Views
1,126
GPGeorge
GPGeorge
A
Search button for more than one field search
Replies
4
Views
202
Uncle Gizmo
Uncle Gizmo

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom