>i have varibel in table name "date"
>i want to filter year form date i try but not done, How thanks
>where summert.year(DATE())=thisform.tyear.value;
If I understand you corectly you have field named date in table named summert and I suppose that the type of that field is Date or DateTime.
Then to get the year portion of that field:
WHERE YEAR(summert.date) = thisform.tyear.value;
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
