'SELECT * FROM provodka_tb WHERE date_format(prov_date, "%m%Y") = date_format(#' + IntToStr(ComboBox7.ItemIndex+1) + '/1/' + ComboBox8.Text + '#, "%m%Y")' 

SELECT * FROM provodka_tb WHERE year(prov_date) = ComboBox8.Text  and month(prov_date)=ComboBox7.ItemIndex  ;

'SELECT * FROM provodka_tb WHERE month(prov_date)= '''+IntToStr(ComboBox7.ItemIndex+1)+''''

DataModule2.ADOQueryPrihod.SQL.Add('SELECT * FROM provodka_tb WHERE month(prov_date)= '''+IntToStr(ComboBox7.ItemIndex+1)+''' AND  year(prov_date)= '''+ComboBox8.Text+''' ;      ');