I'm hoping someone can help me with this.
I have a table with three columns
1 - auto indexed number
2 - product number (repeats depending on date)
3 - date
so product 123 was sold on January 1, 2005, 8:30 AM and again on January 1, 2006, 9:15 PM etc etc etc. Lots of duplicates
How do I query to just say product 123 had 15 sales between January 1, 2005 and January 1, 2006. Is there a way just to count how many between two dates and then export this report directly to excel?
So it would be:
Product id Number of sales
123 15
124 12
Something like that. Are there any tutorials on this?
Thanks