Find last order date for each client

[jef3fowler]

Drawn a blank.

Looking to find the last date each client ordered something.

The query should show each client and the last order date.

2 tables: Clients and orders. clientID in each.

Any hints/directions appreciated. Even blistering attacks on my ability.

Thanks,

Jef

[MMcCarthy]

Jef

We all have to start somewhere. The following query (using your field names of course) should do the job. This will return the clientID, name and last order date (assumes a valid date format for order date). Have a look and if there is anything you don't understand about how it works just ask.

Mary

 
SELECT Clients.ClientID, Clients.[ClientName], Max([OrderDate])
FROM Clients INNER JOIN orders 
ON Clients.ClientID=orders.ClientID
GROUP BY Clients.ClientID, Clients.[ClientName];
 

[jef3fowler]

Thanks Mary. I'll try this today.

Just found The Scripts yesterday. Looks good.

Jef

[MMcCarthy]

Thanks Mary. I'll try this today.

Just found The Scripts yesterday. Looks good.

Jef

Thanks Jef

We're trying to build a community that's friendly to users at all levels. So never be afraid to ask basic questions.

All the experts who volunteer expect is that you post your questions clearly, following the Posting Guidelines ...

http://www.thescripts.com/forum/thread559246.html

and repsond with the results you obtained from their suggestions along with any variations you try.

If you put some work in yourself and respond clearly you'll get a lot of help here.

So far you've done good. Keep it up.

Mary