var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
This is my query design view:
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?
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!
Did you try changing your date column from a "Group By" to a "Where"? Experiment with that.
Originally Posted by ashurakore