helo all,

i have a date field in a table, the date is stored as 2005-12-04 in the database.i want to filter the data on year basis, such as the datalist wil display all files in 2005 when 2005 is selected in the combo dropdown box.

How should i combine both of the querys as one to get the right data in my datlist:

test = "Select * from proposals where date = " & Combo2.Text
strQuery = "Select filename from proposals where bedrijf_ID = " & DataList1.BoundText

Hope you understand what my question is. The query need to meet 2 criteria, one the year in the date field should be equal to the year in the combobox and the bedrijf_id should be equal to datalist1.bound text. And the result shoulbe filename wich is displyaed in the datalist.

thanks in advance