Feb 28 2006, 05:25 PM
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')
Edited by: rfikes on Tue Feb 28 17:40:39 EST 2006.
Feb 28 2006, 05:42 PM
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
Year Selected: Year([WeekEnding]) << This should just display/extract the year value..
Criteria >> =2005
Feb 28 2006, 05:46 PM
That did what I needed.