Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by PATRICKGILL
-
Grouping & Counting Records by Date Ranges
The sales data is daily, but I will be summarizing by month and maybe by week. I think I will have to create a date range calandar table to allow for the zeros for certain periods if no sales have occured.- PATRICKGILL
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Grouping & Counting Records by Date Ranges
I need to generate an Access 2003 query that will produce a data summary of item sales history in monthly ranges that I can adjust. Here is an simplified example data table I want to summarize: ItemCode OrderDate Quantity ABC-0001 5/5/2006 11:59:00 AM 3 ABC-0001...- PATRICKGILL
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
