How can I specify the most recent date in a query?

shaunacol · Nov 1, 2001

I have a CUSTOMERS and ORDERS table. One customer may have many orders.

I would like to produce a query which lists the customer details and the last order they made.

I am trying to do this by placing a condition on the DateofOrder which specifies the most recent one - but am not getting any where - can anyone help please?

Databaseguy · Nov 1, 2001

Look into the aggregate Max function and/or DMax Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How can I specify the most recent date in a query?

shaunacol

Programmer

Databaseguy

MIS

Similar threads

Part and Inventory Search

Sponsor