In my database I have a Month([Date]) field which returns records from the criteria of month "1", "2" through to "12". However I want it to return them for those months only of this year.

Is there a date function where I can have something like
Month([Date]), Year ([=Now])

thanks

You need to use two separate conditions, one to compare on months and one to compare against the current year.

RV