Daily Report, Weekly Report and Yearly Report
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?
Re: Daily Report, Weekly Report and Yearly Report
You would use the date or date range as part of your where clause in your select statement
I.E.
Code:
Select * from MyTable where [date]=#12/26/2013#
Also note that date is a reserved word and should not be used as a field name
