Boris i have error in your code,operator...........
Boris i thing it is because my low knowlade about sql. how is done in one select,
WHERE YEAR(summert.date) = thisform.tyear.value
tyear is a combo