finding first records only

C

ckitzman

Registered User.
Local time
Today, 15:37
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
272
Ken Sheridan
Ken Sheridan
asteropi
Solved Report/Query won't print my results
Replies
13
Views
478
Gasman
Gasman
M
Query with top 15 sorted ascending
Replies
4
Views
501
GPGeorge
GPGeorge
H
Solved Query for the balance stock material
Replies
8
Views
1,139
GPGeorge
GPGeorge
A
Search button for more than one field search
Replies
3
Views
212
Ken Sheridan
Ken Sheridan

Users who are viewing this thread

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