finding first records only

C

ckitzman

Registered User.
Local time
Yesterday, 19:12
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

H
Solved Query for the balance stock material
Replies
8
Views
538
GPGeorge
GPGeorge
T
Solved How to make vba check all records in continuous form not only top one record
Replies
14
Views
504
TMK
T
nicolareina
Single row data query
Replies
13
Views
474
Gasman
Gasman
essaytee
Is it possible: Query/SQL to dynamically display a record/order/position number, without underlying field from a table
Replies
11
Views
626
essaytee
essaytee
A
Solved Problem creating greeting for a letter(access report)
Replies
17
Views
472
Al Kramer
A

Users who are viewing this thread

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