Hello Guys I have a DB using MSAccess 2003 and I have a Table DailyRecord which is DailyRecords Have and Every Record then I want to know how to Select the Daily Report, Weekly Report and Yearly Report from DailyRecords..

DB Example:
Item QTY. Date
Sardines 5 12/25/2013
Item QTY. Date
Foods 5 12/26/2013
Item QTY. Date
Clothes 5 12/27/2013

When i Choose Daily Record Only for One Day to Select..

What Should I do?