Hello,
I am trying to create a query that, for a given date range, will count the number of order of a certain color there are. For example, in a given 7 day period (say May 1 to May 7), we might sell 7 blue units, 5 black units, 9 red units, etc.
Using a Totals line, I am able to Count the number of units sold in the date range, but it also breaks the colors down by individual day in the date rate. So if I sold 2 black units on May 3, 2 black units on May 4, and 1 black unit on May 5, I get individual line items for each date, when I'd really like the color total for the entire date range in one line item.
My current query is:
Field: Color Color PurchDate
Table: Orders Orders Orders
Total: Group By Count GroupBy
Sort: Ascending
Show: Checked Checked Checked
Criteria: >=[StartDate] And <=[EndDate]
As you can tell, I'm just getting going in Access.
Thanks for any pointers.
Trooper13