Hello group,

I was wondering if someone could show me how to choose the year only in a dynamic query.

In the criteria section of my query, could I not write some variation of:
=#31/12/ & [YEAR] & # (my '&' is for concatenation)
-this would be great because all of the dates in this field are december 12, YYYY

Thanks in advance,

-Sean

Just got it! Thanks anyway!

=("31/12/" & [DATE])

-Sean