Fieldnames are not necessarily 'column' names! The fieldname might very well be
"CurrentYear" or simply just "Year" in your WHERE clause. Hard to say without
examining how the data table is constructed in the mdb file. Open it in Access
and study its structure to see how the fields are defined...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion