Hi

I am a noob in access with knowledge of only the basic tools (as displayed by the question).

I am trying to develop an access based database for a small company. I have made few tables, some of them are the "2011/2012 Total Production in $" and ""2011/2012 Total Production in CY."


All four tables have a column "Actual Production"


Now, using query tool, i have to achieve two objectives.

A), to get the maximum and minimum production of each month in a year and
B) to display the date of when the Actual Production was maximum/minimum in the month

I have accomplished task a) which was simple; Make a query, get relevant fields, Summary Max & Min and finally distrubute in month wise. I.e Jan Max 5000, Min 2000...Feb Max 6000 Min 1000

Now what i desire is to display the date of max or min production for the month. So if Jan 15 had 5000, I want jan 15 to be displayed as the max prod date for Month of Jan.

Again, am a noob so please be as simple as possible.

Thank you!

Regards
Abbas