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 TouchToneTommy 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 MiamiDave
-
Nested SQL for Criteria
Thanks. That's part of the solution I've adopted. The issue is I want the answers for 3mos, 6mos, and 12mos on the same query from the same source table. I used a solution similar to that posted three times, one for each total, by adding the source table 3 times (source_1, source_2, source_3)...- MiamiDave
- Post #4
- Forum: Microsoft: Access Other topics
-
Nested SQL for Criteria
I have a large number of records that detail selling by item and location and week. How can I query the table to get the total sales over the last 3mos, 6mos, and 12mos?- MiamiDave
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
