statistical data report

See more:

VB6

I am making a database software
front end is vb 6.0
back end is msaccess
one module is to display statistical data:
there will be a combo box n a command button
where user can select year from a combo box n then can click on command button to generate a graph month wise of the year selected in the above combo box.
my queries are as follows:
1. at form load i need to get distinct year from database. (as we cannot give hard coded years value in database)
how to get it?
2. when user select a particular year then how to get data entries related to that particular year and further how to sort them into 12 different months.
e.g if the user is using s/w since 2008 then it in combo box entry should be
2008
2009
2010
2011
(my query no 1 is how to get this distinct year entries from database)
when user select year say 2009 then when it click on command button it here graph is shown month wise of that particular year
so now how to fetch data year wise n then sort it month wise like
january of 2009
february of 2009
march of 2009
..
...
Thnks.