CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    34

    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?

  2. #2
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,362

    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
  •  





Click Here to Expand Forum to Full Width

Featured