i have a table in which date is written as mm/dd/yyyy now i have a form with a combo box with only year(yyyy) and a buttton which when pressed should generate a report based on a query for that year how can write this query to compare the Year part only.

i mean to say that how do i compare the year in the combo box to the year in the table (not the whole date).


awaiting your replies
thanks in advance

Use the YEAR function:

DoCmd.OpenReport "Your Report Name", acViewPreview, , "Year([Your Date Field]) = " & Me.cboYear

Where cboYear is the combobox.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division