Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Location
    Brooklyn
    Posts
    25

    Red face Unanswered: select data (current week, mtd, ytd)

    Hello,
    I have a table of few columns which are:

    ID, Style, TYpe, loadDate Units Dollars
    1 01 0014 01/01/2006 2 20.00
    2 01 0014 01/29/2006 2 20.00
    3 04 0041 03/24/2004 1 11.00
    4 01 0014 02/21/2005 2 20.00
    4 02 0021 05/21/2004 3 12.00
    4 03 0032 05/12/2005 1 10.50
    5 02 0021 04/04/2006 1 12.00
    5 06 0061 03/21/2003 5 14.00
    5 08 0081 11/12/2002 5 9.50

    Based on this table I have to create a query/report that will show

    id, style, type, current week sum(units) , current week sum(dollars),
    month today sum(units), and month today sum(dollras)
    year today sum(units) and year today sum(dollars)
    group by id, style, type

    I know how to select info based on the datepart(''ww'',loadDate) or month or year.

    But I do not know how to select all at once.


    Please help.

    Thank you

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,472
    Provided Answers: 10
    I would Create each query by then seft

    1. weekly sales
    2. monthly sales
    3. yearly sales

    Then create a New report with 3 sub reports in it
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Jan 2005
    Location
    Brooklyn
    Posts
    25
    will try to do that.
    Thank you for sugestion.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •