Hello,

I have 4 field in my Access database

(1) ID (Autonumber)

(2) Month ( I think I will use numeric value for month and then use 

VBSCript MonthName() to convert it to real month name

(3) Year

(4) Document Name

For each month and year there will be few or many associated documents.



I want to query the database in such way that display of record would be 

like this



March 2002

Document 1

Document 2

Document 3



Febuary 2002

Document  1

Document  2



January 2002

Document 1

Document 2





December 2001

Document 1