crosstab query help

[bronson_mech]

hello frnds i need a help in my database I'm tracking record for year so far i didn't found any problems but now i got a problem the thing is, in my crosstab query row wise company record & column wise month is there for one year all records captured perfectly but starting from jan 2014 the record is accumulated with jan 2013, how to separate this record by year as well as by month

[ItsMe]

Maybe the Year() function?

Dim intYear as integer
intYear = Year(NameOfField)

There are also Day() and Month() functions as well as DatePart('m', #12/12/2012#) which would return 12