I have a statistics report that shows a selected time frame (usually a weeks worth of numbers) along with a Year-to-Date time frame. Is it possible to have a query calculate and create a new field that has the beginning of each year show, for this year, 1/01/2007 and then for next year show 1/01/2008 and so on, without any user intervention. This new year field must show this beginning year date conistently the entire year.

Kevin