Query to extract maximum figures for each date

[vijanand1279]

Hi,



I need help to extract rows with the highest production figures for each entry dates.

I have attached the files for your reference. I tried something but it does not work.

Regards,
Vijay

[boblarson]

Look at what I did in Query1 and then I used that in Query2. I think this is what you asked for.

[vijanand1279]

Hi Bob,

This is what I was looking for. I could understand that you have used Query 1 to get our desired data on Query 2. Thank you so much.

REgards,
Vijay