I Have Data like this :

Date Name Of Product Price
01/05/02 AAA 100
27/05/02 BBB 200
03/05/02 CCC 500
05/05/02 DDD 700

I want to make a query to display the last date (Date: 27/05/02, Name Of Product : BBB and the price is : 200) but this date not the last data. How I can to do that ?

Thank’s

Query and GroupBy "Last" on the Date column.

Gentle Inquirer-

That's two--

Before you go any further: Limit your postings to one thread per question! It's not as if you are going to reach a different viewing audience if you post multiple copies of the same question--think about it.

We see them, we read them, then we decide if it's something we want to respond to. Multiple postings trash the system and most surely reduce the chances of a response since it causes the regular volunteer responders to question the maturity and intelligence of the poster.

Bob