-
February 26th, 2013, 11:54 AM
#1
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?
-
February 26th, 2013, 09:50 PM
#2
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
Last edited by DataMiser; February 26th, 2013 at 09:52 PM.
Always use [code][/code] tags when posting code.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|