Trimester Query

[Dirtrider929]

Does anyone know how to set up a trimester query instead of a quarter? DO I need to do it in VBA or can I do it as a criteria?

I am trying to query historical data into previous year trimesters. Jan-Apr, May-Aug, and Sept-Dec.

Any help or suggestions would be greatly appreciated.

 

[Mihail]

Take a look to Month() function.

 

[namliam]

THis should devide 12 into values of 1,2 and 3
Int(((month(Yourdate)-1)/4)+1)