Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2012
    Posts
    1

    Unanswered: Microsoft Access Aggregate Sales Within a Timeframe Query?

    I was fiddling around with MS Access but got stuck with a problem:

    I want to calculate aggregate sales grouped by product ID within a time frame (1 Jan 2011 to 30 Apr 2011). I tried making a query but all I got is this.

    http://i5.photobucket.com/albums/y200/Aurons/1.jpg

    This is my query design view:

    http://i5.photobucket.com/albums/y200/Aurons/2.jpg

    The query result should have only 74 entries but I got 800+. Is there any way to limit the query to a specific time frame without grouping them by date?

    Any ideas on how to do this?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    When you have a problem with a query, please post its SQL sentence in plain text (when the query is open is design view, click right and select SQL Mode) instead of a screen shot of its design.
    Have a nice day!

  3. #3
    Join Date
    Feb 2012
    Posts
    14
    Quote Originally Posted by ashurakore View Post
    The query result should have only 74 entries but I got 800+. Is there any way to limit the query to a specific time frame without grouping them by date?
    Did you try changing your date column from a "Group By" to a "Where"? Experiment with that.

Posting Permissions

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