The year function should work fine, you just need to make sure that you are passing it a date type field. What do you get if you type:
"? type(mytable.&cField2)" ?
>You found it. I get the same error as in the SELECT.
>
>"Function argument value, count invalid."
>
>I guess I have to find another way to do the year().
kenweber
GCom2 Solutions
Microsoft Certified Professional