Comments by Tinneminy (Top 2 by date)

Thanks for the reply.

Thing is i need to display 10 different tables current status of data like minimum and maximum months data on the basis of distinct [client id].
My Table names are:
tbl_Catalogue_Tax_spend_Analysis
tbl_Catalogue_Overall_spend_Analysis
tbl_Catalogue_Air_Activity
tbl_Catalogue_Hotel_Booking
tbl_Catalogue_Car_Booking
tbl_Catalogue_Lost_Hotel
etc...

I want to show the information like eg.,

Catalogue_Tax_spend_Analysis May 2009 July 2011
catalogue_Overall_spend_analysis May 2009 June 2011


Now as per the solution given by digimanus, how should i do this.i mean i m confuse. Could you explain this with an example.