Hi!



Maybe this is what are looking for:

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=3D154





Hakan



-----Ursprungligt meddelande-----

Fr=E5n: Chirag Shah [mailto:chiragiit@y...]

Skickat: den 21 februari 2002 21:23

Till: ASP Databases

=C4mne: [asp_databases] Help needed in SQL query





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




$subst('Email.Unsub').