Running a date query that groups items by Quarter. What do I need to put in the criteria part to tell it to only run for 2005 or 2006, etc.

My Quarter field is: WeekEnding By Quarter: Format$([Time Cards].[WeekEnding],'\Qq yyyy')


Thanks!

Edited by: rfikes on Tue Feb 28 17:40:39 EST 2006.

Hi
Create a new query grid column and place your field [WeekEnding] which will be converted to reflect the year and set your criteria for this column to =2005
eg:

Year Selected: Year([WeekEnding]) << This should just display/extract the year value..
.............
Criteria >> =2005

HTH's

Thanks!

That did what I needed.

You're welcome..