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!
Search results for query: *
- Users: rubetube56
- Order by date
-
HELP!! with complex recursive date query!
Well basically it didnt compile because I don't understand the Access SQL syntax that well. For instance, I did not realize that Sum(Order.Amount) should be Sum([Order].[Amount]). That is just goofy SQL, that is why I don't understand Access that well.- rubetube56
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
HELP!! with complex recursive date query!
This didn't even compile for me :(- rubetube56
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
HELP!! with complex recursive date query!
Hello all, I need help writing a 'recursive' date query where the user would enter in the date range (ex. 1/05/06 - 11/11/06). What I want the query to do is go through each month and count up the number of orders, then go through all of the orders and give a total number of orders. Sounds...- rubetube56
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
