I would reccomend you double check the value of cField2 and it's associated field. Since the only function you're using is the year function, and there is obviously no problem with year(date()), it must be in year(mytable.&cField2)

>Error message =
>
>"Function argument value, type or count is invalid."
>
>Sorry I forgot to put it in my question.