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

Look up Max or search here.

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 they're something we want to respond to.
Multiple postings trash the system and most surely reduce the chances of a response since they cause the regular volunteer responders to question the maturity and intelligence of the poster.

Right now, you're teetering on the borderline.

Bob


[This message has been edited by raskew (edited 05-27-2002).]

could u be more clear on what actuall u wanted/....i am online inyahoo...my id is sramesh123_2000

do contact me here for immediate answeres

ramesh